ActiveSheet.Name ="new name"

or

worksheets("sheet1").Name ="New Name"

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Jack" wrote in message
...
Hi,


I just wonder how to change a sheet name the from vba code in
excel...

Thanks for your help

Jack