View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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 -