locking cells
When you go to protect the sheet, deselect the tick box that says "Select
Locked Cells". Then you won't be able to actual have that cell selected and
attempt to change it.
The problem comes when you try double clicking on that locked cell as it
will still pop up the message.
Sorry I couldn't have been more help.
"greg" wrote:
Hello,
I am wondering if there is a way to just protect cells so text cannot be
changed?
without having the msgbox coming up that states that the cells are
protected?
Or is there a way to suppress that message box from popping up? even when
protection is on?
thanks for any help
|