Autofilter in Excel 2007, Protected Sheet

[Jhunnieboy]

Hi,
Could you please help me enable the autofilter after a macro has been run? the macro unprotects and protects at the end but this still wont work. I can't seem to edit the filter as it is disabled/unclickable. my macro would adjust the filter but sometimes they wanted to edit the filter from the row itself.

By the way, before I protect the sheet, I made sure that autofilter is on as I have read from other posts.

Please Login or Register  to view this content.

Thank you.

[TMS]

Suggest you upload a sample workbook. Need to see the Protect code ... and what the data structure looks like.

Regards, TMS