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

--
Message posted from http://www.ExcelForum.com

? anyone

--
Message posted from http://www.ExcelForum.com

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.

--
Regards,
Tom Ogilvy


"Michael Wise " wrote in
message ...
I am not wanting my sheet renamed to the file name. The sheet has been
set to what the name needs to be but upon the save event it renames the
active sheet to match the filename. Any stops for this.
Michael


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com