+ Reply to Thread
Results 1 to 3 of 3

Filtering and sorting on protected sheet

  1. 09-26-2018, 02:35 PM #1
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Filtering and sorting on protected sheet

    Hi,

    I have a data set and I have protected first 2 rows of the sheet for adding some logos there.

    I have protected it with the following recorded macro

    Please Login or Register  to view this content.
    It does allow sorting but why the AutoFilter button is disabled. How user can filter the records?

    Help would be greatly appreciated

    Best Regards
    Imran Bhatti
    Attached Files Attached Files
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  2. 09-27-2018, 07:55 AM #2
    Tsjallie
    Tsjallie is offline
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Filtering and sorting on protected sheet

    You need to have the Autofilter active before you protect the sheet.
    Cheers!
    Tsjallie



    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...
    Reply With QuoteRegister To Reply
  3. 09-27-2018, 10:59 AM #3
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Filtering and sorting on protected sheet

    Thanks. That did the trick.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. 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
  3. Sorting and filtering a protected worksheet
    By JonesyCC in forum Excel General
    Replies: 7
    Last Post: 05-27-2015, 12:25 PM
  4. 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
  5. 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
  6. filtering a protected sheet
    By deth in forum Excel General
    Replies: 1
    Last Post: 06-01-2012, 06:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1