+ Reply to Thread
Results 1 to 2 of 2

Auto-Filter on a protected sheet

  1. #1
    Registered User
    Join Date
    03-17-2005
    Posts
    2

    Auto-Filter on a protected sheet

    Is there any way to make the auto-filter functionality work (for a single column) on a worksheet that is protected? I can unprotect the column, but the filtering functionality is not accessible. Plus, I do not want to allow data changes to the cells within the column.

    Any help is appreciated!

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning AaronC

    There are some tips here dealing with exactly that issue, including some code that you can use in your application to enable autofilter in a protected sheet with the protection remaining in place.

    http://www.contextures.com/xlautofilter03.html#Protect

    HTH

    DominicB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1