+ Reply to Thread
Results 1 to 4 of 4

Filtering/Sorting a Locked Worksheet

  1. 03-13-2018, 05:50 AM #1
    Cmorgan
    Cmorgan is offline
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    346

    Filtering/Sorting a Locked Worksheet

    Morning,

    I'm having trouble locking/protecting documents, but still leaving staff able to filter and sort. Any help you could give would be great. I've mocked up a simple Excel sheet and attached it:

    - I have locked columns A and D, which I have shaded orange for ease.
    - I want staff to be able to enter data into columns B and C, so I have not 'locked' these columns.
    - I have then locked the sheet with the simple password ps123
    - When I locked the sheet i ticked the boxes to allow you to filter and sort
    - However when I go to filter or sort it doesn't allow me.

    I'm not sure what I'm doing wrong. Many thanks.
    Attached Files Attached Files
    Last edited by Cmorgan; 03-13-2018 at 04:42 PM.
    Reply With QuoteRegister To Reply
  2. 03-13-2018, 09:04 AM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filtering/Sorting a Locked Worksheet

    maybe read this: Protect a worksheet

    Sort
    Use any commands to sort data (Data tab, Sort & Filter group).
    Note: Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting.

    Use AutoFilter
    Use the drop-down arrows to change the filter on ranges when AutoFilters are applied.
    Note: Users cannot apply or remove AutoFilter on a protected worksheet, regardless of this setting.
    Reply With QuoteRegister To Reply
  3. 03-13-2018, 04:41 PM #3
    Cmorgan
    Cmorgan is offline
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    346

    Re: Filtering/Sorting a Locked Worksheet

    Many thanks
    Reply With QuoteRegister To Reply
  4. 03-13-2018, 07:05 PM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filtering/Sorting a Locked Worksheet

    You are welcome

    Have a nice day
    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. Use of Group / Ungroup filtering in a locked worksheet
    By DNA Cal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2016, 09:56 AM
  2. Protect worksheet but allow table functions like sorting/filtering
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-27-2015, 03:47 PM
  3. Sorting and filtering a protected worksheet
    By JonesyCC in forum Excel General
    Replies: 7
    Last Post: 05-27-2015, 12:25 PM
  4. 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
  5. Locked worksheet based upon date and locked columns when worksheet is not locked
    By ruralbrew in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2011, 05:18 PM
  6. Sorting and Filtering the records to new worksheet
    By saikumar in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-20-2009, 02:24 AM
  7. Sorting (or maybe filtering) worksheet with multiple data in cells
    By SafetyDaveG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2008, 05:34 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