Hi Dave, Thanks for your suggestion. Perhaps it would be a useful
alternative to trying to disable the error box. I have also created a macro
to run on startup that hides the menu bar at the top of the screen to make it
a little more difficult to get into the file to change things.

"Dave Peterson" wrote:

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