Hello
Depending on your Excel version, you may allow for selecting locked cells
and selecting unlocked cells.
This option is available from Tools|Protection|Protect Worksheet.

HTH
Cordially
Pascal

"Art Caragh" a écrit dans le message
de news: ...
I have command buttons on every sheet relating to every sheet
When I activate protection on my sheet called "Totals" and when I click on
the "Totals" from any of the other sheets i receive a debug message.

When protection is off, the command buttons function normally
The code reads
Private Sub CommandButton16_Click()
'
Application.Goto Reference:="Totals"
End Sub

I would be very grateful for any ideas