Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosave:: off
Hello, I am trying to turn off the saving msg box that flashes up whenever document is closed, i am currently running a macro that opens man different files, but when they are closed back down i have to press n to the saving options. Anyway i can stop this? Thanks in advance, Have a good da -- PaulOakle ----------------------------------------------------------------------- PaulOakley's Profile: http://www.excelforum.com/member.php...fo&userid=2510 View this thread: http://www.excelforum.com/showthread.php?threadid=39014 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosave:: off
Activeworkbook.Close SaveChanges:=False
or set it to True based on your preference. -- Regards, Tom Ogilvy "PaulOakley" wrote in message ... Hello, I am trying to turn off the saving msg box that flashes up whenever a document is closed, i am currently running a macro that opens many different files, but when they are closed back down i have to press no to the saving options. Anyway i can stop this? Thanks in advance, Have a good day -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=390144 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosave add-in | Excel Worksheet Functions | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
autosave | Excel Worksheet Functions | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming |