blackie42
10-22-2009, 06:55 AM
I have a Workbook_open event that hides all but one of the sheets.
I then have a sub that allows the user to select the sheets they want to keep visible and use.
I want to disable the WB-Open routine as the WB is saved for the first time (so next time its opened the sheets selected will appear only). I will prompt a rename of the WB at that point
Assume the instruction would be in the 'before save' or 'before close' event.
Not sure how to go about deleting the WB_open code.
Any help appreciated
regards
Jon
I then have a sub that allows the user to select the sheets they want to keep visible and use.
I want to disable the WB-Open routine as the WB is saved for the first time (so next time its opened the sheets selected will appear only). I will prompt a rename of the WB at that point
Assume the instruction would be in the 'before save' or 'before close' event.
Not sure how to go about deleting the WB_open code.
Any help appreciated
regards
Jon