| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto-execute macro....
How can you get a macro to automatically execute as the file is being closed,
but before the file is saved ? |
|
#2
|
|||
|
|||
|
You could put your code in the BeforeClose event of the ThisWorkbook sheet
module. You can then add to your code to see if the file has been saved or not. You can check the files Saved property. Bill Horton "Eric @ SEASH, Evansville" wrote: How can you get a macro to automatically execute as the file is being closed, but before the file is saved ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for auto sum | New Users to Excel | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Auto Run a Macro | Excel Discussion (Misc queries) | |||
| Execute Macro | Excel Discussion (Misc queries) | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
