| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving as variable file name | Excel Discussion (Misc queries) | |||
| Saving a workbook with a variable name | Excel Programming | |||
| Saving a workbook with a variable name | Excel Programming | |||
| Saving Workbook with Variable | Excel Programming | |||
| Saving Registry variable to ini file | Excel Programming | |||
Threaded Mode
