Maybe you could stop them from using the cursor keys/mouse to select locked
cells on protected worksheets.

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

Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).

Daibrush wrote:

Under normal circumstances, when you try to edit data that is protected you
get an error message dialog box saying that the data needs to be unprotected.
Does anyone know of a way that this function can be disabled so that the
user cannot see this box? This causes a problem because it effectively tells
them how to overcome the protected sheet, thus rendering the protection
pretty much pointless.

--

Dave Peterson