-
Worksheet_change event executed on a wrong sheet?
Hi everyone,
Is it thinkable that a worksheet_change event is executed on another sheet? the case is that a particular messagebox sometimes appears on sheet B while the worksheet_change code, that fires this messagebox, is on the sheet A. Untill now i couldn't reproduce this event myself, but one of the users of my programme claims that it happens sometimes.
I think the circumstances under which this happens are as follows. The worksheet_change event will be executed if a particular cell is empty. Normaly this cell should contain a j or a n. While this particular cell is active (and not empty) a user can activate another sheet by pushing the sheet tab. On this sheet the messagebox appears that was fired by the worksheet_change event on the previous sheet. The strange thing is that the code shouldn't be executed at all, because the cell wasn't empty. Is it possible that the fact the cell was active (selected) before changing sheets causes this problem? What can i do to prevent this?
Best regards,
Stranno
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules