Message 1 of 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello
I have a multiple sheet drawing and i want to replace views by suppress and unsuppress them according to different model configurations e.g "1" or "2".
I used the rule below and this worked well on a single sheet drawing, but when I got more sheets this only works on the active sheet.
How to solve this on a multiple sheet drawing? I have searched the forum without any luck.
If Parameter("30627.iam.Deling") = "2" Then ActiveSheet.View("VIEW1").View.Suppressed = True ActiveSheet.View("VIEW2").View.Suppressed = True ActiveSheet.View("VIEW3").View.Suppressed = False ActiveSheet.View("VIEW4").View.Suppressed = False Else ActiveSheet.View("VIEW1").View.Suppressed = False ActiveSheet.View("VIEW2").View.Suppressed = False ActiveSheet.View("VIEW3").View.Suppressed = True ActiveSheet.View("VIEW4").View.Suppressed = True End If
Solved! Go to Solution.