Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Protection

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patrick - 05 Sep 2007 04:22 GMT
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


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.