| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a macro run when the user closes a workbook
On the VBE editor,
double click "ThisWorbook" then use this. Private Sub Workbook_BeforeClose(Cancel As Boolean) your macro here End Sub Regards, Cesar Zapata "KD" wrote in message ... Is there any way I can get a macro to run automatically everytime a user closes down the workbook? Many thanks KD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making NT user/login user appear in a cell | Excel Worksheet Functions | |||
| Using macro to stop user from emailing workbook | Excel Discussion (Misc queries) | |||
| I want a macro to save a workbook as a user inputted cell | Excel Discussion (Misc queries) | |||
| looping a calculation until workbook closes | Excel Worksheet Functions | |||
| Workbook Unexpectedly Closes Immediately | Excel Discussion (Misc queries) | |||
![Cesar Zapata[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
