Workbook "Sheet" Naming

C

comotoman

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

Bernie Deitrick

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
Merge Multiple workbook sheets into one workbook 0
Populate Data from Summary Sheet 5
Update workbook pages- how? 2
Help to create a macro 2
formula between two workbooks 1
Log Sheet 1
HELP - A formula or sheet you want to move or copy contains the name .... 0

Top