Custom error message

[Poweruser99]

I am using Excel 2002. currently I have locked my cells so they may not be edited. If a user tries to edit a cell, Excel displays a custom error message stating that cells are locked and protected.

Is there a way to replace this message with one of my own? I know you can do this is Access or VB.

Any help would be appreciated.

 

[gh61]

I'm not aware of any way of doing this in Excel. A workround might be to use the Worksheet_Change event to trap any attempt to change cells you want to protect, then warn the user accordingly.

HTH

Graeme

 

[Poweruser99]

Can you give me an example for that with the code.

Thanks

 

[PHV]

In your object browser press the F1 key on the Change event of the Worksheet object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884