Using Excel macros from Vision objects
 

We have a large Excel workbook that has a front-end where we draw diagrams.
Each object on the diagram has a macro assigned to it and this is the primary
user interface for the program. I would like to be able to draw the diagram
in Visio rather than Excel because this is the standard method within our
industry. Is it possible to use a Visio drawing and assign Excel macros so
that when you click on Visio object it activates the macro within Excel?
Brian Maskell

Visio supports VBA, so if you're going to port, I'd move the whole operation
over...
Sorry I can't help more specifically.
*******************
~Anne Troy

www.OfficeArticles.com


"Brian Maskell" <Brian wrote in message
...
We have a large Excel workbook that has a front-end where we draw
diagrams.
Each object on the diagram has a macro assigned to it and this is the
primary
user interface for the program. I would like to be able to draw the
diagram
in Visio rather than Excel because this is the standard method within our
industry. Is it possible to use a Visio drawing and assign Excel macros so
that when you click on Visio object it activates the macro within Excel?
Brian Maskell