Saving workbook causes new sheet and lockup
 

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!

Saving workbook causes new sheet and lockup
 

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!

Saving workbook causes new sheet and lockup
 

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 -

Saving workbook causes new sheet and lockup
 

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

"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 -

Saving workbook causes new sheet and lockup
 

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 -

Saving workbook causes new sheet and lockup
 

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!

On Apr 13, 8:44 pm, JLGWhiz wrote:
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 -- Hide quoted text -

- Show quoted text -