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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top