Turning Off Protection Alerts

[elchupacabra]

Hi all

Here's my problem: Is it ppossible to disable (preferably through vba) the alerts associated with a protected sheet?

For instance, if a user attempts to edit the contents of a locked cell in one of my protected sheets, the alert "The cell or chart you are trying to change is protected and therefore read-only" pops up.

I have a workbook containing 3 protected worksheets over which various macros can be performed (by using the Workbook_Open event to set the UserInterFaceOnly property to "False").

I have tried to include the following line in this very same Workbook_Open routine, but it doesn't disable the alert quoted above:

Application.DisplayAlerts = False


Really could do with some help, if you don't mind


El C

 

[ZVI]

Hi!

There is no standard way to avoid this message.
But you can switch off checkbox 'Select Locked Cell' at Protection of worksheet (ActiveSheet.EnableSelection = xlUnlockedCells) to avoid selection of protected cells as well as trying of editing it.

UserInterfaceOnly should be set to True (not to False as you wrote) for accessing to protected cells from VBA.

Regards,
Vladimir

 

[Smitty]

Welcome to the Board!

Unfortunately there's no suppressing that warning.

But you may be able to get around that by setting the wb to Read Only, depending on what you're trying to do.

 

[elchupacabra]

Thanks for the replies

Yeap, sorry, the UserInterFaceOnly property is in fact set to True.

Unchecking the "Select Locked Cells" as you recommended seems to have done the trick, so thank you very much for that.