Hello everyone, I'm marking this as [solved] but really, I have just had time to think about it and come up with a different way.
The problem I could foresee was that eventually, I would be protecting the sheet so that formulas would be preserved, and when protected the group show/hide detail options wouldn't have worked. My code for a simple button would have become longer and longer to solve a problem that is easily handled by the ribbon buttons for showing and hiding a group of cells.
I have had to find some way of showing/hiding cells on another part of the sheet, my code is pasted below. It is very similar to what I wanted for this thread - a button to hide/show certain rows. The macro, when assigned to a button on the sheet will look to see if row 29 is hidden, and either hide it or show it depending on what it finds. Since it simply hides the cells, there is no trouble when a sheet is protected.
Bookmarks