Saving workbook causes new sheet and lockup

[dickie]

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!

 

[Guest]

I'm wondering what you have as "Workbook_BeforeSave" code.

 

[dickie]

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.

 

[Guest]

Take a look and see if there is any code attached to "My Workbook".

 

[Guest]

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]

Thanks, Barb & GWhiz, I think I stumbled onto the problem when I
looked in the VBA Project Explorer and found Modules 11 & 12, they
just had the Option Explicit declarations, no Subs. I haven't had the
problem since I removed these rogue Modules, I think I inadvertently
put them in trying to copy code from one XL workbook to another?

Thanks again for your help!