ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disable AutoRecover (https://www.excelbanter.com/excel-discussion-misc-queries/104454-disable-autorecover.html)

Daniel M

Disable AutoRecover
 
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




All times are GMT +1. The time now is 04:20 PM.

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