Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Did you hear that Frank? Kevin wants you to become Alias #3, Just FYI | Excel Discussion (Misc queries) |