Changing the tab's text
 

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

Thank you
Paulo.

Changing the tab's text
 

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.

Changing the tab's text
 

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.

Changing the tab's text
 

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


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

Changing the tab's text
 

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.

Changing the tab's text
 

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.