View Full Version : Disable alert message

07-23-2012, 11:13 AM
Hello all, can we disable "The cell or chart you are trying to change is protected..." alert?

Any help/suggestion would be appreciated.

07-23-2012, 01:48 PM
As far as I know, that is one of the alerts that can't be supressed.
Avoiding it would be the way to go.

If Not (Worksheets("mySheet").ProtectContents) Then
Rem do stuff
End If

Kenneth Hobs
07-23-2012, 02:03 PM
If you mean changing by code, do something like this in the Thisworkbook's Open event.

Sheet1.Protect "ken", UserInterfaceOnly:=True