+ Reply to Thread
Results 1 to 8 of 8

Sorting and filtering a protected worksheet

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    52

    Sorting and filtering a protected worksheet

    Hi

    I was wondering if anyone as a solution for this one. I have excel 2007 and a worksheet where I have two columns unlocked, and the rest of the columns are locked, and protected. What I need is a way to easily sort & filter the locked columns. Can anyone help?

    Thanks
    Dave

  2. #2
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Sorting and filtering a protected worksheet

    see if this helps u

    http://excelribbon.tips.net/T000137_...orksheets.html

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Sorting and filtering a protected worksheet

    Only if "Sort" and "Use autofilter" were specifically allowed by whoever protected the sheet.
    Glenn



  4. #4
    Registered User
    Join Date
    08-29-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Sorting and filtering a protected worksheet

    Thanks for the reply Jayajay I have tried that website and their solution doesn't work.

  5. #5
    Registered User
    Join Date
    08-29-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Sorting and filtering a protected worksheet

    Hi Glenn I was the one who protected the sheet and I selected Sort and Use Autofilter and it didn't work. it allows me to ctrl-f and find items but not sort or filter.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Sorting and filtering a protected worksheet

    Can you post your sheet? If not, can you mock up a small sample to test?

  7. #7
    Registered User
    Join Date
    08-29-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Sorting and filtering a protected worksheet

    Yes I can please find the sheet attached.
    Attached Files Attached Files

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Sorting and filtering a protected worksheet

    Take a look at this... at least it provides an explanation and possibly lets you find a way forward.

    http://blog.softartisans.com/2013/10...ed-worksheets/

+ 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. 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
  2. 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
  3. filtering and sorting in protected sheets
    By Christian Galbavy in forum Excel General
    Replies: 2
    Last Post: 10-25-2005, 12:05 PM
  4. Sorting Protected Worksheet
    By Vonner in forum Excel General
    Replies: 1
    Last Post: 07-16-2005, 11:05 AM
  5. [SOLVED] Sorting on a protected worksheet
    By Sue in forum Excel General
    Replies: 6
    Last Post: 06-12-2005, 05:05 AM

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