VBA - Allow filtering and sorting on Protected Sheet

[cacos]

Hi everyone!

I'm facing quite a challenge on this one. I have a table on a worksheet that needs to stay locked (users can't modifiy the cells) but still users should be able to filter and sort that table.

I have tried everything and saw forum solutions but none work.

Here's my best shot so far (useless):

With Sheet1

.Protect Password:="test", AllowFiltering:=True, AllowSorting:=True, userinterfaceonly:=True
        .EnableAutoFilter = True
        .EnableSelection = xlNoRestrictions
       
       
End With

Thanks!!

 

[NARAYANK991]

Hi ,

Have you checked out this link ?

http://www.pcreview.co.uk/forums/sorting-tables-protected-worksheets-t3994706.html

Narayan

 

[cacos]

Thanks Narayan! The worksheet_selectionchange approach works. It's weird this can't be handled from the sheet.protect command.

Thanks again