VBA code to populate Excel Tab Text
 

I would like to use VBA to enter tab's name in Excel's worksheet tab from a
cell in the worksheet. Lets say I have the word "Mickey Mouse" in cell A1 in
my worksheet. I would like to auto populate the worksheet's tab to show
Mickey Mouse. Any help here?

VBA code to populate Excel Tab Text
 

Hi CB

this should work

With ActiveSheet
ActiveSheet.Name = [A1]
End With

S