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

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.

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.