+ Reply to Thread
Results 1 to 3 of 3

Autofilter sort protected sheet

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-21-2006
    Location
    Australia
    MS-Off Ver
    O365 PC Version 2301
    Posts
    122

    Autofilter sort protected sheet

    I have the sheet protected with options to allow sort and autofilter. Everything on the autofilter works except for the sort ascending and sort descending options. Is there any way to make it work without unprotecting the data?

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    A button to launch your macro which will turn off the protection, sort and turn the protection back on ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Contributor
    Join Date
    04-21-2006
    Location
    Australia
    MS-Off Ver
    O365 PC Version 2301
    Posts
    122
    I was thinking that may be the only way. Means I would have to have cells to select which data column to sort and which way (ascending/descending). I could do that but was hoping there may be a way to allow the sort on autofilter to still work. I'm guessing not.

+ 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