Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi:
The following does not stop the alert message box if an attempt is made to enter data into a protected cell. Any advice as to how to stop the alerts would be greatly appreciated. Private Sub Worksheet_Activate() Worksheets("Sheet1").Unprotect Application.DisplayAlerts = False Worksheets("Sheet1").Protect End Sub Thanks TK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Displayalerts = value (is not working for me) | Excel Programming | |||
application.displayalerts is not working | Excel Programming | |||
Application.DisplayAlerts in IE | Excel Programming | |||
Application::DisplayAlerts not working | Excel Programming | |||
application.displayalerts | Excel Programming |