Hi Forum,

Could you help me understand if there is a way to change the caption in a button when the sheet is protected?

Already have this code running Ok when the sheet is NOT protected; even runs well if i set on the "Allow other users to" Edit Objects in the Protection/Tools Menu. Unfortunately, i have more Objects in the sheet that i don't want to be edited or moved by the user. Is there a way to do the change of caption in the button with the Protection on?

Any help or leading ideas appreciated, thanks for your thinking.

Jose

This is what i have written so far:

If "condition1" Then
ActiveSheet.Buttons("BotonAvisos").Caption = "Click para ver Avisos de Error"
With ActiveSheet.Buttons("BotonAvisos").Characters(Start:=1,Length:=30).Font
.Name = "Geneva"
.FontStyle = "Bold"
.Size = 14
.ColorIndex = 3
End With
Else
ActiveSheet.Buttons("BotonAvisos").Caption = "Datos OK"
With ActiveSheet.Buttons("BotonAvisos").Characters(Start:=1, Length:=8).Font
.Name = "Geneva"
.FontStyle = "Bold"
.Size = 18
.ColorIndex = 10
End With
End If