Lost save option in excel after creating Macro's

  • Thread starter Thread starter liamothelegend1
  • Start date Start date
L

liamothelegend1

Using excel 2002 (OS=XP PRO)
when creating Macros before have always relied on the dialog box tha
normally comes up when you close excel -Asks whether you want to sav
changes to "personal.xls".
Now When I close it down it doesnt give me the option any more .And
dont know another way of saving macros.Any ideas :mad
 
It sounds like the application.displayalerts property has been set to false
by one of your macros. Search for that property and make certain that the
macro that sets it to false also sets it back to true.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
You must log in or register to reply here.

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

Personal Macro 1
Personal.xls will not open when I open excel 2
Double clicking an Excel file is not working. What's wrong? 3
Excel 2007 unrecognized file format in Excel 2003 More options 1
Book2 on open; click on X's twice to close Excel 2007? 0
Excel 2007: Saving a file with a Macro 1
Excel crashes when trying to save. 2
Saving when closing excel 1

Back
Top