Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn OFF Autosave just for a particular workbook?
Is there a way to do this? I know you can set the Autosave to ONLY save the current workbook, but is there a way to code the opposite - something in the workbook's code to say "while this workbook is open, never Autosave it"?
Thanks for any help, T |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn OFF Autosave just for a particular workbook?
Tony,
Application.AutoRecover.Enabled = False What you should do is determine what the setting is first, then make your change and than return the setting to its original setting when they change or close the workbook. One thing to keep in mind this is a globle setting for all workbooks, not just yours. Knowing this you might wanna use the workbook activate and deactivate events. Bill " wrote: Is there a way to do this? I know you can set the Autosave to ONLY save the current workbook, but is there a way to code the opposite - something in the workbook's code to say "while this workbook is open, never Autosave it"? Thanks for any help, T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosave workbook as unique file | Excel Discussion (Misc queries) | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
How to write a autosave macro for a shared workbook? | Excel Programming | |||
How do I turn on Excel Autosave in Office XP? | Excel Discussion (Misc queries) | |||
autosave workbook | Excel Programming |