elchupacabra
New Member
- Joined
- Oct 24, 2007
- Messages
- 3
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
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