Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro when file closes
I need to run a macro every time my workbook close. Can this be done?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro when file closes
in the vb editor, double click the "thisworkbook" entry under microsoft excel
objects and select workbook from the dropdown and then before close from the event dropdown Private Sub Workbook_BeforeClose(Cancel As Boolean) ' your macro End Sub or use sub auto_Close() ' your macro end sub in a general module -- Gary "Patrick C. Simonds" wrote in message ... I need to run a macro every time my workbook close. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Command Bar when excel file closes | Excel Programming | |||
ComboBox1_Change - is triggered when file closes | Excel Programming | |||
File closes without prompting to save | Excel Discussion (Misc queries) | |||
calculation - prompting to save when file closes | Excel Discussion (Misc queries) | |||
Excel 2003 File Closes In 2000 | Links and Linking in Excel |