locking cells

[greg]

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

 

[NateBuckley]

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.

 

[Dave Peterson]

If you use xl2002+, you'll see two options under:
tools|protection|protect sheet
to allow users to select locked cells
and to allow users to select unlocked cells.

If you're using xl2k or earlier, you can protect the worksheet in code:

Sub Auto_Open()
With Worksheets("Sheet99999")
.Unprotect Password:="hi"
.EnableSelection = xlUnlockedCells
.Protect Password:="hi", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End With
End Sub

In xl2k and below, this setting isn't remembered when you close the workbook and
reopen. Setting it in code was the only way to do this.

 

[greg]

Thanks,
I will take a look at both.