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
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