Protection Message

F

Fred

When a worksheet is protected and a cell is locked then an Error message
appears whenever the user attempts to edit the cell.
Is there an event that I can tap into so that I can display my own message
and run my own routine instead of the standard message?

Thanks for any help
Fred
 
D

Dave Peterson

Maybe you could just stop them from selecting locked cells on your worksheet:

Option Explicit
Sub auto_open()
With Worksheets("Sheet1")
.Protect Password:="hi"
.EnableSelection = xlUnlockedCells
End With
End Sub

And xl2002 added the ability to set the enableselection property via the
userinterface.
 
Top