| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| how to email one sheet only of a workbook | Excel Discussion (Misc queries) | |||
| copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
