Workbook "Sheet" Naming
 

I am creating a workbook that will keep my company up to date on yearly
job reviews. Sheet one has a name, and I would like to type the "Job
Name" on sheet 2, cell a3 and have it appear as sheet 2 name. Can this
be done?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472174

Copy the code below, right click on sheet 2's tab, select "View Code" and paste the code in the
window that appears.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$3" Then Target.Parent.Name = Target.Value
End Sub



"comotoman" wrote in message
...

I am creating a workbook that will keep my company up to date on yearly
job reviews. Sheet one has a name, and I would like to type the "Job
Name" on sheet 2, cell a3 and have it appear as sheet 2 name. Can this
be done?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472174

done that, then what? sorry im a novice at this:)


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472174

Type a name into cell A3..... If you have put the code into the correct place, the name of the sheet
will change to whatever you've typed.

HTH,
Bernie
MS Excel MVP


"comotoman" wrote in message
...

done that, then what? sorry im a novice at this:)


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472174

Please HELP!!!!!! thank you


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472174