Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving a sheet in a new workbook | Excel Programming | |||
Saving a sheet in a workbook as .csv but not changing workbook name | Excel Programming | |||
Saving one sheet within a workbook | Excel Discussion (Misc queries) | |||
saving sheet as new workbook | Excel Programming | |||
Saving only 1 sheet of a workbook | Excel Programming |