Private Worksheet change function conflicts with another Code...Help

[swade730]

Hi,

I have a code embedded in a sheet so that when the sheet is selected a msg box pops up.

I also have another code that selects this sheet, which causes the message box to appear and disrupts the workflow of the other macro...



Here is the code that is in the sheet...

Please Login or Register  to view this content.

Can I alter this to be activated somehow after I run the first code...


I'm thinking call it from the other macro but the sheet change event is critical...

[quekbc]

In the code that activates that particular sheet, you can put this command to disable the worksheet activate event from being triggered.

Please Login or Register  to view this content.

Then you can set it back to True after you've done activating it.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

At the beginning of your Sheet Activate code set your EnableEvents to false. Then at the end Set it back to true.

[swade730]

At the beginning of your Sheet Activate code set your EnableEvents to false. Then at the end Set it back to true.

Your referring to the sheet that has the code (Triggered event) or the Macro that selects the sheet ...?

[JOHN H. DAVIS]

I was referring too the code in Post#1. Can you share the code which activates the Sheet in Post#1? Is it necessary? Or can you use instead:

Please Login or Register  to view this content.