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 / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Programatically Filter a protected shared worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neill - 21 Nov 2007 10:56 GMT
How can I filter a protected shared worksheet?
1. I have allowed filtering in protection & can filter the protected
worksheet manually but if I try using code it says its protected. Code used
to filter Selection.AutoFilter Field:=3, Criteria1:="LK"
2. I can't unprotect then filter because it's a shared workbook.
3. I have used Protect UserInterfaceOnly:=True but this resets after closing
& cannot be reapplied as you cant protect a shared workbook.

Regards
Neill
Dave Peterson - 21 Nov 2007 13:53 GMT
You're going to have to make a choice--share the workbook or allow filtering.

Or come up with a different idea.

Debra Dalgleish once suggested something like this:

Create a new sheet
Keep it unprotected
Fill it with formulas like:

=if(sheet1!a1="","",sheet1!a1)

so all the formulas retrieve their values from the "real" sheet.

Then apply filtering to that unprotected sheet.

You may want to remind the users that changes to this sheet are not
important--it's only there to allow them to use the filter.  (Maybe give all the
cells in that sheet a different fill color to make it look different.)

> How can I filter a protected shared worksheet?
> 1. I have allowed filtering in protection & can filter the protected
[quoted text clipped - 6 lines]
> Regards
> Neill

Signature

Dave Peterson

 
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.