Stop Workbook_Open macro running...

**KML1976** · 06-30-2016, 09:51 AM

I have a workbook that has a Workbook_Open macro, however I want to be able to have a message box that displays and if the user presses 'OK' the macro won't run.

I tried this, but it doesn't work and I don't know why.

Please Login or Register  to view this content.

**Olly** · 06-30-2016, 10:31 AM

Try:

Please Login or Register  to view this content.

**mikeTRON** · 06-30-2016, 10:35 AM

Or even easier, try the following sample.

Please Login or Register  to view this content.

**Olly** · 06-30-2016, 10:40 AM

Originally Posted by mikeTRON

Or even easier, try the following sample.

Please Login or Register  to view this content.

Ah, but the msgbox will wait until you get a response. Using the shell popup, it will wait a set period, then if no response is received, it will continue...

**mikeTRON** · 06-30-2016, 10:45 AM

Originally Posted by Olly

Ah, but the msgbox will wait until you get a response. Using the shell popup, it will wait a set period, then if no response is received, it will continue...

That is a VERY valid point.

I guess if I am giving someone the authorization to cancel something I think I want them to make the explicit decision. Ha

**KML1976** · 06-30-2016, 11:25 AM

I've tried Olly's suggestion, if I press OK then it doesn't run but the message doesn't disappear after 10 seconds - it remains open and therefore the macro doesn't run.

Any suggestions?

thanks

**mikeTRON** · 06-30-2016, 11:33 AM

Originally Posted by KML1976

I've tried Olly's suggestion, if I press OK then it doesn't run but the message doesn't disappear after 10 seconds - it remains open and therefore the macro doesn't run.

Any suggestions?

thanks

Interesting, it also doesn't work for me, and Google tends to show it is a proper pain to diagnose.
http://stackoverflow.com/questions/4...value-from-vba
http://stackoverflow.com/questions/3...mer-expiration