Advertisement
Guest User

Untitled

a guest
Feb 28th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Dim sObject As Shape
  2. For Each sObject In ActiveSheet.Shapes
  3. If sObject.Visible = False Then
  4. sObject.Visible = True
  5. Else
  6. sObject.Visible = False
  7. End If
  8. Next
  9.  
  10. If ActiveSheet.Shapes("Rectangular Callout 6").Visible = False Then
  11. ActiveSheet.Shapes("Rectangular Callout 6").Visible = True
  12. Else
  13. ActiveSheet.Shapes("Rectangular Callout 6").Visible = False
  14. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement