Worksheets Names

[waderw]

I am trying to figure out how I can name a worksheet(as an object) allow the user to change the sheet name and still be able to call the worksheet by the original name that I gave it. For example if you look in the project explorer you can name the worksheet in the "properties" window but you can also name the sheet by renaming the tab in the workbook in Excel's main window.

 

[NateO]

You can refer to the sheet by it's index number:

sheets(1)

or it's code (module) name:

sheet1

These will respond irrespective of tab name.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-05-03 08:36

 

[Russell Hauf]

Try using the CodeName property of the Worksheet object.