Do not want sheet renamed

[Michael Wise]

I am not wanting my sheet renamed to the file name. The sheet has bee
set to what the name needs to be but upon the save event it renames th
active sheet to match the filename. Any stops for this.
Michae

 

[Michael Wise]

? anyone

 

[Tom Ogilvy]

If you save it as a workbook, this shouldn't happen. I suspect you are
saving it as something other than a workbook then reopening it. Since it
isn't a workbook, excel doesn't record workbook related changes you have
made (such as cell formatting or column widths or worksheet names). Thus
when you open it again, you are back where you started.

 

[Michael Wise]

Tom,
I guess im confussed a bit. Although it would be justified being tha
i'm new at this. The statement you make about saving as a workbook ha
me. In my code below my understanding would be that it is being save
as a workbook. Take a look and let me know, Thank you.

ActiveWorkbook.SaveAs ("J:\sdo common\wise\pce\reports\auto generate
reports\ " & Format(Date, ("mmm-dd-yy")) & " Weekly Compliance.xls")

Michae