Code for Using Autofilters on Protected Workbooks

Hi All

I was wondering if anyone could help me with something. I have a workbook with 6 different tabs at the bottom that i want to protect. There are Autofilters on each of these sheets and i want to be able to use these without having to unprotect the document.

I have been informed that there is some code you can put in to enable you to use autofilters in a workbook while it is protected, does anyone know what this might be?

Many Thanks

FYI, you can do this without code. When you protect the worksheets you will be prompted to "Allow all users of this worksheet to:" and you can simply check the box "Use AutoFilter".

I have a second workbook that i also want to do this for however it has 106 worksheets so i was hoping there was something that can be done to stop me having to do each sheet individually.

Hi Laura

I tried this but it didn't work. My header row for the data starts in A4 and i changed it to this but it didn't work. I also tries copying this code into the "ThisWorkbook" section as well as on the sheet as well but neither did anything. Is there something i'm missing?

Thanks