View Single Post
 
Old 12-03-2018, 06:28 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,966
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

As a concept (ie I didn't test this because I don't know where you got your Checkboxes from) try these macros
Code:
Public Sub CheckBox1_Click()
  ShowHideLayer "To Be Form", CheckBox1.Value
End Sub

Public Sub CheckBox2_Click()
  ShowHideLayer "SHC As Is Form", CheckBox2.Value
End Sub

Public Sub CheckBox3_Click()
  ShowHideLayer "Works As Is Form", CheckBox3.Value
End Sub

Public Sub ShowHideLayer(sLayerName As String, bShow As Boolean)
  Dim aPage As Visio.Page, aLayer As Visio.Layer, aCell As Visio.Cell
  
  For Each aPage In ActiveDocument.Pages
    For Each aLayer In aPage.Layers
      If aLayer.Name = sLayerName Then
        Set aCell = aLayer.CellsC(visLayerVisible)
        aCell.Formula = bShow
      End If
    Next aLayer
  Next aPage
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote