Hi

I have a workbook that is protected. When someone tried to change the
content of the workbook the generic error message "The cell or chart
you are trying to change is protected and therefore read-only".
Is it possible to replace that message with a customised message box?
If so anyone please advice me how to do this?

Thank you very much in advance.
Peddie

You could add a worksheet change event, trap any changes, and if the sheet
is protected throw up a custom MsgBox. But you will probably still get the
other one , and so it hardly seems worth the effort to me


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"peddie" wrote in message
oups.com...
Hi

I have a workbook that is protected. When someone tried to change the
content of the workbook the generic error message "The cell or chart
you are trying to change is protected and therefore read-only".
Is it possible to replace that message with a customised message box?
If so anyone please advice me how to do this?

Thank you very much in advance.
Peddie