View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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