using command buttons on protected worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a worksheet which contains a list (2 columns by 130 rows) that
will be searched on a regular basis by other users, but I want to protect the
sheet to prevent changes.
For quick navigation to different sections of the list I have created
several command buttons, each with the following code:

Private Sub button100_Click()
Application.Goto Reference:=Worksheets("Codes").Range("A46"), _
Scroll:=True
End Sub

Currently, when I protect the sheet & try to use the buttons I recieve the
following error message:

Run-time error '1004':
Method 'Gto' of object '_Application' failed

Is there a way to protect the list but still allow the user to use the
command buttons? Or is there another method for navigating a protect
worksheet?
 
Back
Top