Thread: Auto Save
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ray Batig Ray Batig is offline
external usenet poster
 
Posts: 74
Default Auto Save

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