View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
prabhuraaman prabhuraaman is offline
external usenet poster
 
Posts: 4
Default disable autorecover

You could disable autorecover for a single workbook by using the
"disableautorecover" property.
Try it out

Daniel M wrote:
Hi

I'm trying to check the box for disable autorecover under the tools options
and save tab permenantly for a user in excel2003 but can't see a way of doing
this as its not in the registry according to MS articles. I did read about a
VB scripting to possibly do this and created the following..

Set objExcel = CreateObject("Excel.Application")

objExcel.AutoRecover.enabled = FALSE

objExcel.Quit

This however doesn't check the Disble Autorecover box. Has anyone had a
success with this?

thanks

Daniel