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

Bug when Sheet Protection Activated
 

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

Bug when Sheet Protection Activated
 

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

Bug when Sheet Protection Activated
 

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

Bug when Sheet Protection Activated
 

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