Document won't save

G

glenlee

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).
 
O

Otto Moehrbach

Look in the workbook module for a Workbook_BeforeSave macro. If there is
one, does it cancel the save command? HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding macros to toolbars 1
losing command button functionality 4
Make custom buttons point to local macros always 2
XLSM File Will Not Save Macros in Quick Access Toolbar 4
Final attempt save as binary question 6
Macros don't work when file name changes 2
Is it possible 1
Assigning Macros in Excel 2007 1

Top