Lost save option in excel after creating Macro's

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
 
B

Bob Flanagan

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
 
Top