Community
My company has a lot of drawings including sheet1 (we may name it customer) for clients to approve, sheet 2, sheet 3.....for production. When we activate sheet1, we would like the rest sheets to exclud from count and print. If we activate the rest sheets, we would like to exclude sheet1.
I have searched on the Internet to try to get some help, but there is not much for me. Could you please give me a hand?
Regards
Finally I figured it out after a long hour study. Please see below the iLogic
Thanks
'Exclude from printing and count sheet(s) oDoc = ThisApplication.ActiveDocument Dim oSheet As Sheet If (ActiveSheet.Name = "abcd") Or (ActiveSheet.Name = "abcd:1") Then For Each oSheet In oDoc.Sheets If i = 0 Then oSheet.ExcludeFromCount = 0 oSheet.ExcludeFromPrinting = 0 i = i + 1 Else oSheet.ExcludeFromCount = 1 oSheet.ExcludeFromPrinting = 1 End If Next Else For Each oSheet In oDoc.Sheets If i = 0 Then oSheet.ExcludeFromCount = 1 oSheet.ExcludeFromPrinting = 1 i = i + 1 Else oSheet.ExcludeFromCount = 0 oSheet.ExcludeFromPrinting = 0 End If Next End If