I have a worksheet ("WS1") with a Worksheet_Deactivate procedure.
We have come across the following curious situation: When we navigate from WS1 to certain (but not all) other worksheets within our application, the Worksheet_Deactivate only fires every other time. This means that if we navigate from WS1 to WSA, then back to WS1 and then return to WSA, the Deactivate will only fire the second time we go from WS1 to WSA. Should we do the following, though:
Deactivate will not fire. It will only fire if we visit the same "Bad List" worksheet twice or navigate to a "Good List" one.
E.g.:
If we navigate to one of the worksheets which are on the "Good List", it will fire immediately, regardless of which worksheet we navigated to WS1 from.
E.G.:
I tried changing the name of a worksheet to see if that may be the cause, but it does not seem to be related. I can not find any other "common denominator" between the "Good List" worksheets or the "Bad List" ones.
One more point: If I put a message box in the deactivate procedure (e.g. MsgBox "Fired!"), then it fires every time. I do not want a message box there, though
!
Any help would be appreciated!
Thanks,
TemiU
We have come across the following curious situation: When we navigate from WS1 to certain (but not all) other worksheets within our application, the Worksheet_Deactivate only fires every other time. This means that if we navigate from WS1 to WSA, then back to WS1 and then return to WSA, the Deactivate will only fire the second time we go from WS1 to WSA. Should we do the following, though:
- WS1
- WSA ("Bad List")
- WS1
- WSB ("Bad List")
Deactivate will not fire. It will only fire if we visit the same "Bad List" worksheet twice or navigate to a "Good List" one.
E.g.:
- WS1
- WSA ("Bad List")
- WS1
- WSA ("Bad List")
If we navigate to one of the worksheets which are on the "Good List", it will fire immediately, regardless of which worksheet we navigated to WS1 from.
E.G.:
- WSA ("Bad List")
- WS1
- WSThisOneFires ("Good List")
I tried changing the name of a worksheet to see if that may be the cause, but it does not seem to be related. I can not find any other "common denominator" between the "Good List" worksheets or the "Bad List" ones.
One more point: If I put a message box in the deactivate procedure (e.g. MsgBox "Fired!"), then it fires every time. I do not want a message box there, though

Any help would be appreciated!
Thanks,
TemiU

Last edited: