Changing the tab's text

[Paulo de Arruda Borelli]

How can I change a tabs' ("Sheet1", "Sheet2" and so on) text?

Thank you
Paulo.

 

[Niek Otten]

Hi Paulo,

Double-click on the label and type your text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[paulo]

Sorry, I was not clear! I need to do this through VBA!

 

[David Adamson]

Put the new sheet name in cell a1 then run the code


Sub Change_name()
ActiveSheet.Name = Range("a1")
End Sub

 

[Fer]

Or:

Sheets(1).Name = "yourName"
Sheets(2).Name = "yourOtherName"

Fer

 

[Peter Huang]

Hi Paulo,

If you still have any concern on this issue, please feel free to let me
know.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.