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 |
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 |
All times are GMT +1. The time now is 11:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com