Control Bar Menu - Run VB Code Via Macro

Control Bar Menu - Run VB Code Via Macro - Action Failed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Silver - 09 Sep 2005 17:30 GMT

I don't know how to run a public function from a command bar, so I've called
a Macro which does it.

But the function has a cancel button which makes the macro burp with that
disgusting HALT dialogue.

Is there a way to watch for the cancel condition from the VB code within the
macro, and to just cancelevent on the function?

Thanks,
Jason Silver

Reply to this Message

Alex Dybenko - 10 Sep 2005 06:25 GMT

Hi,
you can call a public function using: =MyFunction() syntax in Action
property

Then you can add a error handling to your function to catch all errors

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I don't know how to run a public function from a command bar, so I've
>called
[quoted text clipped - 9 lines]
> Thanks,
> Jason Silver

Reply to this Message