all you need is
activesheet.name = "sheet1"
exactly as shown

--
Don Guillett
SalesAid Software

"Ginny" wrote in message
om...
I was using a macro in exel 2002, and now have exel 2003.
The coding for changing the name of the active sheet (Which was:
Active sheet.Select ; ActiveSheet.Name = "sheet1") does not work
with my new exel. Has something changed?
Thanks