MrExcel Publishing
Your One Stop for Excel Tips & Solutions

use tab name

Posted by jeff lawson on June 14, 2001 6:41 AM

I would like to use the tab name as the "title" of my worksheet. How do I do this. For instance cell 1 would have "Customer", because the tab name is "Customer". Obviously, I would want cell 1 to update dynamically when the tab name is changed.

Posted by zen on June 14, 2001 7:37 AM

you acn change the 'title' from sheet one to 'customer' by clicking the properties button on the 'Control Toolbox' and changing it the top 'Title' (obviously) box.

is that any help, or am bark up the wrong tree


Posted by zen on June 14, 2001 7:38 AM

I ment (name)...

Posted by zen on June 14, 2001 3:41 PM

it's late and i just got what you mean!

use Cells(1, 1).Value = Name in VBA

any help