I have built macros which hide and display certain rows depending on which objectbutton a user clicks. When I protect the worksheet (and I've tried setting various privileges) and click on the appropriate objectbutton, the macros fail stating that the worksheet has to be unprotected to run them. It seems to fail on the code:

Selection.EntireRow.Hidden = False

Any ideas on how to solve this issue?

Hi
In your buttons event procedure you can do the following.

eg.
Private Sub CommandButton1_Click()
   Sheet1.Unprotect
   'do what you ned to do
   Sheet1.Protect
End Sub

Cheers
Karsten