You definitely have code somewhere that produces the new sheet tab. To
search for it, open the Visual Basic Editor (Alt + f11) and double click on
in the Project Window on ThisWorkbook, Sheet1, Sheet2...etc. until you find
the code. If you have more than one module listed in the Project Window,
check each of them for the code that creates a new sheet named Module 9.

"dickie" wrote:

Barb, I have nothing in the VBA code about saving. This happens when I
try to save the XL workbook. It isn't happening with the XL workbooks
where I don't use VBA.

On Apr 13, 2:24 pm, Barb Reinhardt
wrote:
I'm wondering what you have as "Workbook_BeforeSave" code.



"dickie" wrote:
When I attempt to "save as", or Ctrl-S, certain of my Excel 97
workbooks, this results in a new sheet tab named Module 12 appearing.
If I right click on this tab and select delete, the tab dissappears
and I can continue to work in that workbook. Any other action locks up
the Excel program and I have to Ctrl-Alt-Del and End Task, lose
whatever I've done.

This is quit vexing and I would be most appreciative of any and all
advice and help!- Hide quoted text -

- Show quoted text -