Hello All,

Is it possible to use a Macro to AutoFilter data on a shared workbook?
The macro will filter data using Autofilter option of excel, but its not working only when the sheet & workbook is protected and the workbook is shared.
I have created a simple example of what i want & attached along with this post. please have a look and let me know if there is any solution.

Thanks in advance,
Prashanth