Worksheets Names

waderw · May 3rd, 2002, 09:18 AM

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 · May 3rd, 2002, 09:31 AM

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

Code:

sheets(1)

or it's code (module) name:

Code:

sheet1

These will respond irrespective of tab name.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-03 08:36 ]

Russell Hauf · May 3rd, 2002, 09:33 AM

Try using the CodeName property of the Worksheet object.

May 3rd, 2002, 09:31 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You can refer to the sheet by it's index number: Code: sheets(1) or it's code (module) name: Code: sheet1 These will respond irrespective of tab name. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-03 08:36 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 09:18 AM	#1
waderw Board Regular Join Date: Apr 2002 Posts: 85	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.

May 3rd, 2002, 09:33 AM	#3
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Try using the CodeName property of the Worksheet object.