Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Document won't save
I have a multi-sheet workbook that has numerous buttons which have
macros assigned to them. Clicking on the button sends the user to a particular spreadsheet, prints a spreadsheet, etc. All the buttons work fine. However, recently when I attempt to save the file (either via File Save As or Save), I get a message box saying the document is not saved. Same error message if I attempt to save to a new file name. The workbook is not protected. Any suggestions? I suspect the macros assigned to the buttons because if I disable the macros, the file will save. Of course then I lose the macros that control the buttons. I'm using Office 2000, (same problem with Office 2002). |
#2
|
|||
|
|||
Look in the workbook module for a Workbook_BeforeSave macro. If there is
one, does it cancel the save command? HTH Otto "glenlee" wrote in message ... I have a multi-sheet workbook that has numerous buttons which have macros assigned to them. Clicking on the button sends the user to a particular spreadsheet, prints a spreadsheet, etc. All the buttons work fine. However, recently when I attempt to save the file (either via File Save As or Save), I get a message box saying the document is not saved. Same error message if I attempt to save to a new file name. The workbook is not protected. Any suggestions? I suspect the macros assigned to the buttons because if I disable the macros, the file will save. Of course then I lose the macros that control the buttons. I'm using Office 2000, (same problem with Office 2002). |
#3
|
|||
|
|||
Did you ever solve this?
"glenlee" wrote: I have a multi-sheet workbook that has numerous buttons which have macros assigned to them. Clicking on the button sends the user to a particular spreadsheet, prints a spreadsheet, etc. All the buttons work fine. However, recently when I attempt to save the file (either via File Save As or Save), I get a message box saying the document is not saved. Same error message if I attempt to save to a new file name. The workbook is not protected. Any suggestions? I suspect the macros assigned to the buttons because if I disable the macros, the file will save. Of course then I lose the macros that control the buttons. I'm using Office 2000, (same problem with Office 2002). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot edit and save | Excel Worksheet Functions | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Excel should not delete document after trying to send email | Excel Discussion (Misc queries) | |||
When I try to save a workbook, I get the message "document has no. | Excel Discussion (Misc queries) | |||
Save Data to Excel Web Document | Excel Discussion (Misc queries) |