Link to home
Start Free TrialLog in
Avatar of Michael Keith
Michael KeithFlag for United States of America

asked on

Make a sheet tab name equal to a cell

Is there a way to make the name of a worksheet tab equal to a cell value.   Essentially I want someone to type their name in cell "A1" and then have that name become the tab name.  Is this possible?
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Something like this?
With ActiveSheet
    .Name = .Range("A1").Value
End With

Open in new window

Avatar of Michael Keith

ASKER

How would this activate when they type in the cell?
Er, well you'd have to run the macro. Is this a single sheet, any sheet...?
Single sheet
ASKER CERTIFIED SOLUTION
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That works.  Thanks!