Thread: Auto Save
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Auto Save

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