![]() 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. ![]() ![]() 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |