Hi All

- I have a protected sheet.
- If a user attempts to type into a locked cell, I would like a custom dialog
box to appear, rather than the default ("the cell or chart you are trying to
change is protected and therefore read-only.....")
- I have successfully implemented this using the Worksheet_BeforeDoubleClick
or Workbook_SheetBeforeDoubleClick event, but can't work out how to achieve
this when the user attempts to type directly into a cell.

Any suggestions appreciated.

Thanks in advance.

Paul Martin
Melbourne, Australia