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