locking the cells without protecting the worksheet does no good anyway. The
solution he suggested means users can not even actually select locked cells,
so they will never recieve a message.
Ben

--
When you lose your mind, you free your life.


"milly" wrote:

thanks but I have some cells not a sheet to lock...so...when the user want to
edit, I want that NO message appears...

"jjk" wrote:

I use a workaround where I dont allow the users to select the locked
cells.
This can be enabled while protecting the worksheet using the menu.
or programtically
sheet1.EnableSelection = xlUnlockedCells
sheet1.Protect

Hope it helps.
Regards,
Jayant