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
zen
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
zen
