![]() |
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? |
Saving a variable value
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" wrote in message ... 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? |
Saving a variable value
Hi Bob,
I'm just starting out with VBA. Could you explain what this procedure does? thanks "Bob Phillips" wrote: 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" wrote in message ... 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? |
Saving a variable value
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) "ed" wrote in message ... Hi Bob, I'm just starting out with VBA. Could you explain what this procedure does? thanks "Bob Phillips" wrote: 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" wrote in message ... 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? |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com