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.
