to kevin RE CloseSwitch
 

Kevin

under the project explorer double click on workbook
put the Public CloseSwitch under the declarations
set the CloseSwitch to true under the workbook_open event
and the select case in the workbook before_close event

None of it is in a module.

being public the CloseSwitch can be changed in other
procedures such as your macro