MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Run a macro on close/exit of a spreadsheet.


Posted by Dwight W. Reed, Jr. on August 03, 2001 4:23 PM

I am trying to figure out how to have Excel email the managers of a department when a workbook has changed. I know how to send the email (using outlook). I have that code. The part I have not been able to do is send the email only if the workbook (particularly a worksheet) has changed and on exit or close from the workbook.


Posted by Jim on August 03, 2001 4:38 PM

Dwight,
I'm sure one of the experts will answer this completely
and i would if i could, but it sounds like it is
a combination of 2 events
1)worksheet_Change "your code"..........
2)worksheet_BeforeClose"Your code"........
I wish i could be more help
Jim

Posted by Dwight W. Reed, Jr. on August 03, 2001 4:46 PM

Thanks someone else asked the same thing further down.

Posted by Dwight W. Reed, Jr. on August 03, 2001 4:47 PM

Meaning I got my answer.