ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2002 autoRecover settings (https://www.excelbanter.com/excel-programming/376419-excel-2002-autorecover-settings.html)

NickHK

Excel 2002 autoRecover settings
 
Unchecking the options in XL2002, I get this code.

Application.AutoRecover.Enabled = False
ActiveWorkbook.EnableAutoRecover = False

Does this mean that AutoRecover can be selectively disabled on a WB basis,
assuming Application.AutoRecover.Enabled =True ?
The Help is not that clear .

NickHK



Dave Peterson

Excel 2002 autoRecover settings
 
Inside that dialog (tools|options|save tab), the bottom portion is labeled as
"workbook options". So it appears like it to me.

And from Excel's help:

Workbook options section
Disable AutoRecover Disables the AutoRecover feature for the active workbook.


(I do use xl2003, though.)



NickHK wrote:

Unchecking the options in XL2002, I get this code.

Application.AutoRecover.Enabled = False
ActiveWorkbook.EnableAutoRecover = False

Does this mean that AutoRecover can be selectively disabled on a WB basis,
assuming Application.AutoRecover.Enabled =True ?
The Help is not that clear .

NickHK


--

Dave Peterson


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com