I just found it in another post. it's the code Name

Thanks for the help.

"Norman Jones" wrote:

Hi Skid,

I have belatedly see: "NOT THE TAB NAME", so please ignore my suggestion.

However, what do you mean by changing the sheet's name?

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Skid,

Try something like:

'==========
Sub Test2()

Sheets("Sheet1").Name = "New Sheet"

End Sub
'<<==========

---
Regards,
Norman



"skid" wrote in message
...
Hello

I am trying to Change The worksheet name in a macro (NOT THE TAB NAME) is
this possible

Thanks