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
|