Greetings.
I enjoy tinkering with Excel conditional formatting and VBA but it is just tinkering.
I have a garage/machine shop site-map, created in Visio, that I want to 'automate'. I'm looking for suggestions on a direction, possibly using Excel but I'm not sure it will work.
First idea was to add VBA buttons to Visio, but it seemed like a ton of code.
One idea, that might save some coding, is to fill a shape on an Excel sheet with an image/picture (the Visio site map) and set shapes(buttons) on top of each area and piece of equipment.
Next idea is an Excel custom map, with shapes as buttons on top of site-map areas and equipment.
I want the buttons to open drop-down menus, able to: fill Windows Forms, view manuals and docs(.pdf. docx. jpg, etc), input/record data into forms/spreadsheets, etc.
Is this 'doable'? Is there a plug-in available to make doing this easier?
Thanks.
DBoyd2
I enjoy tinkering with Excel conditional formatting and VBA but it is just tinkering.
I have a garage/machine shop site-map, created in Visio, that I want to 'automate'. I'm looking for suggestions on a direction, possibly using Excel but I'm not sure it will work.
First idea was to add VBA buttons to Visio, but it seemed like a ton of code.
One idea, that might save some coding, is to fill a shape on an Excel sheet with an image/picture (the Visio site map) and set shapes(buttons) on top of each area and piece of equipment.
Next idea is an Excel custom map, with shapes as buttons on top of site-map areas and equipment.
I want the buttons to open drop-down menus, able to: fill Windows Forms, view manuals and docs(.pdf. docx. jpg, etc), input/record data into forms/spreadsheets, etc.
Is this 'doable'? Is there a plug-in available to make doing this easier?
Thanks.
DBoyd2