VBA buttons for hide/unhide rows disappear at random

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!

Sorry about that. I edited the first post to include the correct code.

To answer your question: no, the buttons are all in rows that are unaffected by the macro. Their disappearance seems random. Regardless of which button is clicked, sometimes they all disappear, sometimes just a few disappear, and sometimes none disappear.

There is other code in the document, but I have the same problem whether or not I use this other macro. I'm using a ThisWorkbook macro to protect the document because hide/unhide rows will not work with Excel's built-in protection. Here's the code I use for this:

Private Sub Workbook_Open()
With Worksheets("Sheet1")
       .Protect Password:="password", Userinterfaceonly:=True
       .EnableOutlining = True
End With
End Sub

Also, I should mention that I'm not interested in a patch to fix my copy of Excel. This document is meant to go to several people, and I can't expect all of them to repair their software as well.