+ Reply to Thread
Results 1 to 5 of 5

Filtering And Sorting On A Sheet With Protected Columns

Hybrid View

  1. #1
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    263

    Filtering And Sorting On A Sheet With Protected Columns

    Good day, Gurus,

    I have a really puzzling issue. I've got a workbook (sample attached) with several sheets each with certain columns containing formulas which I've got password protected. However, I've noticed that when the "Master Roster" sheet is in the protected state, I'm not able to filter and sort from the column headers. The rest of the sheets work as expected under the protect state. Any idea why this one sheet is behaving like this?

    Thanks in advance for any help or insight anyone is able to offer.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,902

    Re: Filtering And Sorting On A Sheet With Protected Columns

    On the Master sheet, you have not allowed AutoFilter, etc. Compare the options with the other sheets that work.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    263

    Re: Filtering And Sorting On A Sheet With Protected Columns

    Quote Originally Posted by TMS View Post
    On the Master sheet, you have not allowed AutoFilter, etc. Compare the options with the other sheets that work.
    Ah, thank you! I don't know how those options got unchecked as I never did so, but you are correct; it is working now.

    Thanks again!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,902

    Re: Filtering And Sorting On A Sheet With Protected Columns

    The Calendar also does not allow AutoFilter.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,902

    Re: Filtering And Sorting On A Sheet With Protected Columns

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filtering and sorting on protected sheet
    By ImranBhatti in forum Excel General
    Replies: 2
    Last Post: 09-27-2018, 10:59 AM
  2. [SOLVED] allow filtering in a protected sheet
    By sandordan_01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2018, 03:40 PM
  3. How to enable sorting and filtering in a protected sheet?
    By jasminew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2017, 02:13 AM
  4. Sorting and filtering a protected worksheet
    By JonesyCC in forum Excel General
    Replies: 7
    Last Post: 05-27-2015, 12:25 PM
  5. Allow table sorting/filtering in protected sheet.
    By rlbush2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2014, 03:55 PM
  6. Sorting and filtering Locked cells on Protected Sheet
    By Dumy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2013, 02:16 PM
  7. filtering and sorting in protected sheets
    By Christian Galbavy in forum Excel General
    Replies: 2
    Last Post: 10-25-2005, 12:05 PM

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