I'm not sure I understand why your sheet's name changes; but, since you only
have one sheet in the workbook, you can just assign whatever name you want
to the Name property of the ActiveSheet...

ActiveSheet.Name = "Rec"

--
Rick (MVP - Excel)


"Ranjith Kurian" wrote in message
...
I need a macro to change my sheet name.

When i open my workbook it allways have a different sheet name
everyday(the
sheet names are not constant) so i need to change it to as i require
(change
to Rec), i my workbook i will have only one sheet.