Disable alert message

[copyt]

Hello all, can we disable "The cell or chart you are trying to change is protected..." alert?

Any help/suggestion would be appreciated.

[mikerickson]

As far as I know, that is one of the alerts that can't be supressed.
Avoiding it would be the way to go.

[VBA]If Not (Worksheets("mySheet").ProtectContents) Then
Rem do stuff
End If[/VBA]

[Kenneth Hobs]

If you mean changing by code, do something like this in the Thisworkbook's Open event.

[VBA]Sheet1.Protect "ken", UserInterfaceOnly:=True[/VBA]