Visio VBA/Macro Project

The purpose of my project is to automate layers and views in Visio using VBA & VBA macros.

At this point in time I am only using 4 layers. They are pictured in powerpoint presentation.

I am needing VBA code that can be written to do the following:
- Automate layer management, turn on & off specific layers
- A listbox that lists all the frequencies and OTN, preferably via Excel spreadsheet so we can modify the naming convention of what is in the ListBox.

Coding requirements:
- Bottom layer is always visible
- If Nodes = Visible, only Node layer and bottom layer is visible
- If 1530.33 = Visible, BottomLayer = Visible, Nodes=Invisible, All other layers = Invisible
- If 15303.33 OTN = Visible, Nodes=Visible, BottomLayer=Visible, all other layers = invisble
- Would like to use a ListBox to navigate between views.
- Would like to have as many as 48 1530.33 type of layers. A different template with 96 layers as well, if possible.
- Would like to have as many as 10 OTN type of layers
- ListBox is always on active layer
- Would like an excel spreadsheet to rename/name the items in the ListBox

Please let me know if this is something which you can assist.
Thanks
About the recuiter
Member since Sep 2, 2017
Toby Stephens
from Harju, Estonia

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions