G
Guest
Using Office 2003 and Windows XP:
I've been slamming it pretty hard today and maybe I'm just tired, but I'm
having a conflict between events in a workbook and although I'm positive
there is an easy solution, I can't see it right now.
I have the following functions in my ThisWorkbook module:
Workbook_Open contains Function_1 and Function_2
Workbook_Activate contains Function_1 and Function_3
Workbook_Deactivate contains Function_4 and Function_5
Workbook_BeforeClose contains Function_4 and Function_6
How can I keep these functions from duplicating one another. When the user
opens the workbook, the above will fire function 1 twice, causing a problem.
When the user closes the file, function 4 will fire twice; yet when the user
switches between workbooks (or opens or closes the file), I need functions 1
and 4 to run once for their respective events...how can I accomplish this?
Thanks again for your help...
I've been slamming it pretty hard today and maybe I'm just tired, but I'm
having a conflict between events in a workbook and although I'm positive
there is an easy solution, I can't see it right now.
I have the following functions in my ThisWorkbook module:
Workbook_Open contains Function_1 and Function_2
Workbook_Activate contains Function_1 and Function_3
Workbook_Deactivate contains Function_4 and Function_5
Workbook_BeforeClose contains Function_4 and Function_6
How can I keep these functions from duplicating one another. When the user
opens the workbook, the above will fire function 1 twice, causing a problem.
When the user closes the file, function 4 will fire twice; yet when the user
switches between workbooks (or opens or closes the file), I need functions 1
and 4 to run once for their respective events...how can I accomplish this?
Thanks again for your help...