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

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