Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeClose event won't run when closing using macro
I am using 2 workbooks in this example. I have the main log and I have
individual sheets for each employee. Since some people can't even comprehend copy/paste, I am making a macro to select the range from their individual sheet, copy and paste it into the main sheet, and then close the main sheet. The problem I am having is this. In the main sheet, I have a beforeClose event. The event works fine when you manually close the workbook, however when the macro from the individual's workbook closes the sheet, the beforeClose event doesn't run. Why would this be? Also, I did both, write the code myself and record a macro using the excel tool. When I recorded the macro, the beforeClose event ran without any problems. Any help would be greatly appreciated. Thanks, Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeClose event won't run when closing using macro
when the macro from the individual's workbook closes the sheet
The only thing that would stop before_close from running is if this macro had an Application.EnableEvents = False in it. I'd check for that. -- Jim "ETLahrs" wrote in message ... |I am using 2 workbooks in this example. I have the main log and I have | individual sheets for each employee. Since some people can't even comprehend | copy/paste, I am making a macro to select the range from their individual | sheet, copy and paste it into the main sheet, and then close the main sheet. | | The problem I am having is this. In the main sheet, I have a beforeClose | event. The event works fine when you manually close the workbook, however | when the macro from the individual's workbook closes the sheet, the | beforeClose event doesn't run. | | Why would this be? | | Also, I did both, write the code myself and record a macro using the excel | tool. When I recorded the macro, the beforeClose event ran without any | problems. | | Any help would be greatly appreciated. | | Thanks, | Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforeClose Event | Excel Programming | |||
BeforeClose event help | Excel Programming | |||
BeforeClose Event | Excel Programming | |||
How can I detect .xls closing? Not BeforeClose , Like AfterClose? | Excel Programming | |||
How to get out of BeforeClose event without closing? | Excel Programming |