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 Nitin Arolkar
from Andhra Pradesh, India