How to Run a Macro from a Custom Tool Bar?

S

SteveM

I thought this would be easy enough. Want to replicate in Visio what
I can do easily in Excel. Create a Custom Tool bar with macros that
map to a specific model.

But MS decided it wanted to ruin my weekend by leaving that
functionality out of its commands selector.

Can anybody point me to a workaround before I shove an ice-pick in my
eye?

Thanks,

SteveM
 
S

SteveM

You need to make a macro or or program to make user toolbutton and to run
macro. Sample program would be found here or help for ToolbarItem.AddOnName
property.http://msdn2.microsoft.com/en-us/library/ms425791.aspx

Visio is not unified to other Office products, as Visio was not born in
MicroSoft.

Juan,

Thanks so much for the reference with the implementation code. I'll
work through that to make it happen. And now an editorial comment:

WTF! Why the heck must I beg decent guys who have real jobs like Juan
for a solution to this trivial problem! Especially because every
other Macro related command EXCEPT run is offered in the Custom
Toolbar dialog box in Visio! And how long has MS owned Visio now!?
It's that hard to add to one fundamental button that makes Custom
Toolbars worth creating!? This is nuts!

OK, Rant over. I'm spent...

Regards,

SteveM
 
M

MikeM

Steve,

I discovered this "MS Undocumented Feature" today, and I couldn't agree with
you more! (loved the ice pick comment, BTW!) Why did they "assimilate" Visio
if they can't be bothered to make it as fully VBA-enabled as the rest of the
Office products? What, if they didn't come up with the idea themselves then
they're going to selectively leave out some "cool stuff"?? Oh wait, that
would affect 90% of what they sell, so *that* can't be it!

And they wonder why so many people love to bash their company ...

Regards, and thanks for posting the question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top