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

Thank you
Paulo.

Hi Paulo,

Double-click on the label and type your text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Paulo de Arruda Borelli" wrote in message
...
How can I change a tabs' ("Sheet1", "Sheet2" and so on) text?

Thank you
Paulo.

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


"Niek Otten" wrote in message
...
Hi Paulo,

Double-click on the label and type your text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Paulo de Arruda Borelli" wrote in message
...
How can I change a tabs' ("Sheet1", "Sheet2" and so on) text?

Thank you
Paulo.

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


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

Or:

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

Fer


"paulo" escribió en el mensaje
...
Sorry, I was not clear! I need to do this through VBA!


"Niek Otten" wrote in message
...
Hi Paulo,

Double-click on the label and type your text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Paulo de Arruda Borelli" wrote in message
...
How can I change a tabs' ("Sheet1", "Sheet2" and so on) text?

Thank you
Paulo.

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.