Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My sheet is "protected". The user is only allowed to select
locked or unlocked cells. If a user tries to double click on any cell or change data, Excel shows the following message box: "The cell or chart that you are trying to change is protected and therefore read-only." Does anyone know if it's possible to override this default message box? It would be nice if I could display my own custom message box, or run my own subroutine if a user tries to change data on a protected sheet. I doubt it's possible, but I just want to check if anyone here knows how to do this?? Thank you! Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Ribbon control disabled by Excel when sheet is protected - Override with getEnabled? | Excel Programming | |||
Relacing default Excel message box when user attempts to change locked cell on protected sheet. | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Protected Sheet Message | Excel Discussion (Misc queries) | |||
Error message with protected sheet | Excel Discussion (Misc queries) |