Saving a variable value
I have the following macro set to run when I open a workbook.
AutoSaveDetected = AddIns("Autosave Add-in").Installed
I use this to determine if a user has auto save installed. If they do, I
disable it and then enable it again in a BeforeClose procedure.
I have a problem in that if I disable auto save, I think the variable result
changes so that the value ends up as being always false when I run the
BeforeClose procedure and auto save never gets enabled.
Is there a way to have the variable store the value when the workbook is
opened instead of the current value?
|