View Full Version : Disable alert message
copyt
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.
mikerickson
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.