Is there a way for me to intercept whatever event is firing

I don't think so. You might use EnableSelection to limit users to selecting
unlocked cells.

--
Jim
"KR" wrote in message
...
|I have a workbook where the users will be expected to input all data via a
| userform (to ensure standardization of information), and the data that is
| submitted will be added to a worksheet that has cells locked/protected.
|
| Currently, a user can select a cell, but if they try to edit it, they get
| the standard Excel "this cell is protected, if you want to change it
| unprotect the sheet, and you may be asked for a password" message.
|
| Is there a way for me to intercept whatever event is firing, and pop up my
| own custom message box so I can tell the user /why/ the sheet is locked?
| something more like "This sheet is protected to ensure data integrity.
| Please enter all data through the userform. If you need to edit or delete
| data please contact (name)"
|
| Any help would be greatly appreciated.
| Thanks,
| Keith
|
| --
| The enclosed questions or comments are entirely mine and don't represent
the
| thoughts, views, or policy of my employer. Any errors or omissions are my
| own.
|
|