View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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?