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 - 05 Sep 2007 05:02 GMT
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?

Signature
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...
-----------------------------------------------------------------------
> When I protect a sheet, i get a message when i goto a cell that is fully
> protected that i cant chagne the contents.
[quoted text clipped - 5 lines]
> thanks
> pat
Patrick - 05 Sep 2007 05:10 GMT
unfortunaetly i am using 2000...............
thanks
> Patrick,
>
[quoted text clipped - 11 lines]
> > thanks
> > pat
Dave Peterson - 05 Sep 2007 12:15 GMT
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.
> When I protect a sheet, i get a message when i goto a cell that is fully
> protected that i cant chagne the contents.
[quoted text clipped - 5 lines]
> thanks
> pat

Signature
Dave Peterson