I don't know of a way to prevent this alert from popping although I'd surely
use it if there were one. At least you can prevent people from following
the advice in the alert by assigning a password to the sheet protection so
they cannot turn it off.

--
Jim Rech
Excel MVP
"Daibrush" wrote in message
...
| 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.