Programmatically Halt Macro and Open VB Editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ron - 14 Mar 2008 16:03 GMT

I have an IF statement in a macro. If one branch is selected, I would
like to halt (not end) macro execution and open up the VB editor
window. What code would I use to accomplish this?...TIA, Ron

Reply to this Message

Bob Phillips - 14 Mar 2008 16:17 GMT

Insert

Stop

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have an IF statement in a macro. If one branch is selected, I would
> like to halt (not end) macro execution and open up the VB editor
> window. What code would I use to accomplish this?...TIA, Ron

Reply to this Message

ron - 14 Mar 2008 16:34 GMT

> Insert
>
[quoted text clipped - 13 lines]
>
> - Show quoted text -

Thanks Bob!

Reply to this Message