Sometimes it's easier to search google:

I found this post by Jim Rech:
http://groups.google.com/groups?thre...%40cppssbbsa04

Oh, heck. It's pretty short:

Assuming your question is, given that the Autosave add-in is open how do I
programmatically enable and disable it, there is nothing documented on that
as far as I know. The following are some macros that I hacked out several
years ago that seem to do the job. Fwiw:

Sub EnableAutosave()
ToggleAutoSave True
End Sub

Sub DisableAutosave()
ToggleAutoSave False
End Sub

Sub ToggleAutoSave(Setting As Boolean)
Workbooks("autosave.xla").Excel4IntlMacroSheets("L oc Table") _
.Range("ud01n.Do_Save").Value = Setting
Run "autosave.xla!mcs05.ClearOnTime"
Run "autosave.xla!mcs03.SetOnTime"
Run "autosave.xla!mcs01.CheckCommand"
End Sub


--
Jim Rech
Excel MVP




Ray Batig wrote:

Hi Rob,

After building a test sheet with the VBA code, I tried to stop AutoSave and
got a subscript out of range error. I will keep trying.

Thanks

Rob van Gelder wrote in message
...
Ray,

AddIns("AutoSave").Installed = False
...
Do Stuff
...
AddIns("AutoSave").Installed = True


It's untested.. Please let me know if this works?

Rob


"Ray Batig" wrote in message
hlink.net...
I am running some very long macros which get interrupted by auto save
which
I have enabled. Is there a way to disable auto save from within the
macro
and then re-enable it before exiting the macro? Since I share macros
with
others at work, I probably should check to see if auto save is enabled
first.

Thanks in advance for your help!

Ray






--

Dave Peterson