| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro on exit by red cross
I need to run a macro when an end user closes excel by the red cross.
I'm currently using: Workbook_BeforeClose(Cancel As Boolean) This works fine when they close just the workbook. (I also have a "close and change settings" button they should press) Why do I need this? I am changing the settings from manual to automatic. Thanks in advance, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run macro on exit by red cross
The Workbook_BeforeClose event should run when Excel is closed. Do you have Application.EnableEvents set to False? -- Jim Cone Portland, Oregon USA "CarlosTapas" wrote in message I need to run a macro when an end user closes excel by the red cross. I'm currently using: Workbook_BeforeClose(Cancel As Boolean) This works fine when they close just the workbook. (I also have a "close and change settings" button they should press) Why do I need this? I am changing the settings from manual to automatic. Thanks in advance, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run a macro on exit | Excel Programming | |||
| Run Macro On Exit | Excel Programming | |||
| Macro for cross referencing | Excel Programming | |||
| Exit via macro only? | Excel Discussion (Misc queries) | |||
| on exit macro | Excel Discussion (Misc queries) | |||
Linear Mode
