Protection

[Guest]

When I protect a sheet, i get a message when i goto a cell that is fully
protected that i cant chagne the contents.


well i know this, that was the whole point of protecting the sheet. how do
i get excel to do what access does in forms... ie when i go to a fully
ptoected cell, nothing happens. no error message, no nothing


thanks
pat

 

[Earl Kiosterud]

Patrick,

In later versions of Excel, you can elect to not let the user even select the locked cells
when you protect the sheet. Ergo, no message. This is true in 2002 and 2003, and not true
of 97. DOn't remember about 2000. Might that work for your requirement?

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Guest]

unfortunaetly i am using 2000...............

thanks

 

[Dave Peterson]

If you protect the worksheet in code, you can toggle this setting:

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 fact, in xl2k and below, this setting isn't remembered when you close the
workbook and reopened. Setting it in code was the only way to do this.