Need a button or shape to launch a macro

D

D finner

I have a Visio 2002 diagram with several shapes linked to
an ODBC database.
Visio provides a macro (Tools - Macros - Visio Extras -
Database Refresh) that will update all the shapes at one time.

Ideally, I'd like to have the shapes auto update when the
Visio drawing is updated and figured haveing some way to
auto-launch the macro above would be ideal. In lieu of
that, using a button or shape to launch the macro would be
acceptable.

I tried using a shape with a doubleclick behavior to launch
the macro, but double clicking does not update the shapes.
If I change the macro referenced, the referenced macro
does run so I think I am correctly linking the shape's
doubleclick behavior to the right macro.

I cannot figure out from the available help how one would
write a VBA routine that runs a macro. I've searched Visio
help, Visio Developer Help, this site, and the book
'Developing Microsoft Visio Solutions'. Any pointers are
appreciated.

TIA

Doug
 

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