One macro prevents another from working

**KevinThomas** · 05-07-2009, 03:16 AM

Hi all,
I have a macro built in to one of my worksheets (under view code).

This prompts a user to select either “Ok” or “Cancel” from a message box.

Please Login or Register  to view this content.

I also have a macro that is designed to run upon save or closure of the workbook which is built in to “this workbook”.

Please Login or Register  to view this content.

No for some reason, if “cancel” is selected from the first macro – it prevents the second macro from running on closure. If “ok” (or the first macro is not run) the second one will run perfectly.

Can anyone help please??

**JBeaucaire** · 05-07-2009, 03:19 AM

You have to turn ENABLEEVENTS back on at the bottom of the Worksheet_Change macro:

Please Login or Register  to view this content.

This piece of code MEANS "turn off other macros for now"...so you have to turn them back on when you're done with your code.

**JBeaucaire** · 05-07-2009, 03:27 AM

In fact, I would reorder your macro events to this order, it appears you could accidentally abort your code with the MSGBOX and still leave the events turned off:

Please Login or Register  to view this content.

**KevinThomas** · 05-07-2009, 04:32 AM

Absolute star - thank you very much

**JBeaucaire** · 05-07-2009, 05:32 AM

My pleasure! If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].

(Also, use the "scales" icon across from the post dates to leave Feedback, it is appreciated)