#HIDE PRINT LINES EXCEL 2016 CODE#

With the assumed randomness in the event execution order, there is no point in trying to find a specific pattern that could be encoded to optimize things. This way, should you decide to rename them or something changes, it only needs to be changed in one place. Private Const NameGroupD As String = 'Group 20' Private Const NameGroupC As String = 'Group 19' Private Const NameGroupB As String = 'Group 71' Private Const NameGroupA As String = 'Group 23'

To start refactoring, I'd save the group names in module constants. The order in which the event procedures are executed is not known/assumed to be random.On each click event you hide all but one of them.You have four distinct groups of shapes.Is there any way to do this more efficiently?ДЇirst off, I'll take note of my assumptions: Now the above is somewhat tedious if I plan to add more buttons.

#HIDE PRINT LINES EXCEL 2016 CODE#

I have the following code I'm using to show/hide multiple shape groups in Excel 2016 using VBA and macros: Sub Pic_1_SA_click()ДЄctiveSheet.Shapes('Group 23').Visible = TrueДЄctiveSheet.Shapes('Group 71').Visible = FalseДЄctiveSheet.Shapes('Group 19').Visible = FalseДЄctiveSheet.Shapes('Group 20').Visible = FalseДЄctiveSheet.Shapes('Group 23').Visible = FalseДЄctiveSheet.Shapes('Group 71').Visible = TrueДЄctiveSheet.Shapes('Group 19').Visible = TrueДЄctiveSheet.Shapes('Group 20').Visible = True

Hide print lines excel 2016