+ Reply to Thread
Results 1 to 3 of 3

Disable AutoRecover for specific workbook using VBA

Hybrid View

  1. #1
    Registered User
    Join Date
    11-16-2020
    Location
    New Jersey, USA
    MS-Off Ver
    365
    Posts
    2

    Disable AutoRecover for specific workbook using VBA

    Greetings!

    I know how to turn off "autorecover" for ALL workbooks: application.autoRecover.Enabled=false

    However, I do not want to turn off autorecover for ALL workbooks. Just a specific one. I know this can be done with the Office UI by going to File... Options...Save..."Disable AutoRecover for This workbook only". But I cannot seem to be able to access this setting via VBA code. Is it not accessible or what am I missing?

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: Disable AutoRecover for specific workbook using VBA

    The Workbook object has an EnableAutorecover property that you can set to False.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    11-16-2020
    Location
    New Jersey, USA
    MS-Off Ver
    365
    Posts
    2

    Re: Disable AutoRecover for specific workbook using VBA

    Thanks!

    Figures that on the Application it's .AutoRecover.Enabled.....and on the workbook it's .EnableAutoRecover.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Disable AutoRecover for this workbook only
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2018, 07:41 AM
  2. Disable auto save for a specific workbook
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 11-20-2017, 06:26 AM
  3. [SOLVED] Disable Autorecover for workbooks I open
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 08-23-2017, 10:02 AM
  4. [SOLVED] Macro to save workbook to specific folder with a specific name, then kill/disable itself.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 03:50 PM
  5. disable autorecover
    By Daniel M in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 06:50 AM
  6. Disable AutoRecover
    By Daniel M in forum Excel General
    Replies: 0
    Last Post: 08-11-2006, 05:00 AM
  7. How to disable AutoRecover feature in Excel
    By Vijay in forum Excel General
    Replies: 1
    Last Post: 03-03-2006, 11:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1