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