Changing the Visual Name of a Worksheet to reference a cell

sean98 · Apr 26th, 2002, 10:19 AM

I would like to reference a cell in the Name of the worksheet. This is not the object name but the worksheets name visual to the user.

Any thoughts?

All help is greatly appreciated.

Regards,
Sean

Jay Petrulis · Apr 26th, 2002, 10:21 AM

One way,

ActiveSheet.Name = ActiveSheet.Range("A1")

This can pbe placed in a regular code module or a sheet or workbook module as well.

Bye,
Jay

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

Apr 26th, 2002, 10:19 AM	#1
sean98 New Member Join Date: Apr 2002 Location: Ontario Posts: 26	I would like to reference a cell in the Name of the worksheet. This is not the object name but the worksheets name visual to the user. Any thoughts? All help is greatly appreciated. Regards, Sean

Apr 26th, 2002, 10:21 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	One way, ActiveSheet.Name = ActiveSheet.Range("A1") This can pbe placed in a regular code module or a sheet or workbook module as well. Bye, Jay