Force the running of a Macro on Spreadhseet exit

Hold down the Alt key while pressing F11 on your keyboard to bring up Visual Basic. Double click on This Workbook when Visual Basic Opens. From the first drop down in the right side of VB select Workbook. From the second drop down select Before Close. You can either paste your macro code here or type the name of the macro here and it will run before the workbook closes.

Please Login or Register  to view this content.