Getting a runtime error if I have two workbooks open

Hey Guys,

I have this code in a module. If I have this workbook open and another one and if the other one is active and I close excel with the red x in the corner I get a runtime error with the bit below in red highlighted. I assume I need to add a "Thisworkbook.active" but it doesn't seem to work. I ave tried it in the this workbook code under before close and also in the below module but neither worked.

Please Login or Register  to view this content.

Hey @TMS,

That worked perfect. Thanks a mil.