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

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

Thanks Papou,
I am using Excel 2003 and I have already unlocked the column where the
command buttons are located.

have you any other ideas

"papou" wrote:

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

Art
I did not mean unlock cells from the Format|Cell option.
While activating protection on a worksheet from the Tools|Protection, you
may allow cells selection in the protection options available.
Could you post the error message you receive?

Cordially
Pascal

"Art Caragh" a écrit dans le message
de news: ...
Thanks Papou,
I am using Excel 2003 and I have already unlocked the column where the
command buttons are located.

have you any other ideas

"papou" wrote:

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

Papou,

I have discovered the error. When the macro in the command button executed
to goto "Totals", the active cell was locked and I have managed to unlock it
now and the command button now executes as normal.

Thank you so much for your help and valuable time.

Warm Regards

Art Caragh

"papou" wrote:

Art
I did not mean unlock cells from the Format|Cell option.
While activating protection on a worksheet from the Tools|Protection, you
may allow cells selection in the protection options available.
Could you post the error message you receive?

Cordially
Pascal

"Art Caragh" a écrit dans le message
de news: ...
Thanks Papou,
I am using Excel 2003 and I have already unlocked the column where the
command buttons are located.

have you any other ideas

"papou" wrote:

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