Saving a variable value

[ed]

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?

 

[Bob Phillips]

Why not just disable it within the BeforeClose event as well. Put it in an
On Error Resume Next, and it won't matter if it is already disabled.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[ed]

Hi Bob,

I'm just starting out with VBA.

Could you explain what this procedure does?

thanks

 

[Bob Phillips]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
'your code to disable the addin
On Error GoTo 0

'your code to enable it
End Sub



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)