View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Art Caragh Art Caragh is offline
external usenet poster
 
Posts: 8
Default Bug when Sheet Protection Activated

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