Enable Auto Filter option in Protected Sheet in excel

[ScottR22]

Does anyone know how to Enable Auto Filter option in Protected Sheet in excel?

 

[Peter_SSs]

Welcome to the MrExcel board!

Have you tried selecting this option when you protect the sheet?

 

[ScottR22]

Yes and this will allow you to manually sort but i need to use the auto sort into ascending and descending order of the whole list which does not work?

 

[Peter_SSs]

What happens if you select both these?

 

[ScottR22]

This does not work either

 

[Peter_SSs]

This does not work either

It works for me, so there must be something different about how our worksheets are set up.

Perhaps you could share a small dummy sheet with XL2BB and explain just what you are trying to do in relation to that worksheet.