PDA

View Full Version : How to use of Macro to AutoFilter data on a shared workbook?



prshnthvn
05-21-2010, 01:35 PM
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