Hi -
I have 5 buttons in my spreadsheet. Each of the 5 buttons expands/contracts a few rows below it. Each button has a separate macro to control it, since each button corresponds to a different set of rows. Here is the code I used (found from another thread). Unfortunately I can't attach the confidential document:
Sub Packages()
With Rows("42:50")
.Select
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
After I click a couple of buttons in the spreadsheet, weird things start to happen. Some buttons will disappear, while others don't, and sometimes the button I'm pressing disappears. Other people have had similar problems and blame it on a bug in Excel 2010, although I haven't found a solution that works for me. It's likely that it is just a bug in Excel because the buttons appear/disappear at random in different patterns.
Does anyone know of a viable workaround for this? One possibility I could imagine is code that tells the button to always remain visible? I am new to using macros, so I would be thankful for anything to point me in the right direction. Thanks!
Bookmarks