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 recuiterMember since Mar 14, 2020 Dharamveer
from Tolima, Colombia