Unable to filter on protected documents

[TraceyPughe]

Yes the answer is normally to tick the filter option before protecting! However, this issue is occuring for only two people who have the same laptop and version of Excel:

excel 2000 (9.06926-SP-3)

Any help would be gratefully received

[Paul Sheppard]

Yes the answer is normally to tick the filter option before protecting! However, this issue is occuring for only two people who have the same laptop and version of Excel:

excel 2000 (9.06926-SP-3)

Any help would be gratefully received

Hi Tracey Pughe

Right click the excel logo left of File, then select View code and paste the following code to the This Workbook module

Please Login or Register  to view this content.

Change sheet 1, sheet 2 to match the protected worksheets, change range ("A3") to match the cell where your filters start