Hello,

I am running an excel report with many tabs.
What I would like to do is to have the TAB of a specific shee
reference a cell (lets say $A$1) for that specific sheet I am on.

For examble, tab 1 will reference cell $A$1 which is the name of
person.
Tab 2 will reference another name specific to the cell and tab it i
on.

At the end, each tab should have a different name per the cell/tab i
is referencing.

How would it do this? do I need to do this in VBA? if so, can you writ
the code out?
I am not VBA proficient...AT ALL...

Please help!!!

Thank

--
Maxwell-500
-----------------------------------------------------------------------
Maxwell-5000's Profile: http://www.excelforum.com/member.php...fo&userid=2605
View this thread: http://www.excelforum.com/showthread.php?threadid=39407

Maxwell,

This will do what you want. Put it into a standard module, run i
manualy.
You could change the macro to fire on change. (I think)

Sub RenameTabs()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ws.Name = Range("A1").Value
Next
End Sub

This help?
Dave
Maxwell-5000 Wrote:
Hello,

I am running an excel report with many tabs.
What I would like to do is to have the TAB of a specific shee
reference a cell (lets say $A$1) for that specific sheet I am on.

For examble, tab 1 will reference cell $A$1 which is the name of
person.
Tab 2 will reference another name specific to the cell and tab it i
on.

At the end, each tab should have a different name per the cell/tab i
is referencing.

How would it do this? do I need to do this in VBA? if so, can you writ
the code out?
I am not VBA proficient...AT ALL...

Please help!!!

Thank

--
Piranh
-----------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2043
View this thread: http://www.excelforum.com/showthread.php?threadid=39407