Try this Jack

Sub test()
On Error Resume Next
ActiveSheet.Name = "Hi"
On Error GoTo 0
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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