BeforeClose event won't run when closing using macro

[ETLahrs]

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

 

[Jim Rech]

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
|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