Sorry don't understand your reply.

Regards
Neill


"Dave Peterson" wrote:

Yep. That was my point.

Neill wrote:

I am using Excel 2003 SP2

I can filter manually, but if I try using VB it says its protected.

Regards
John

"Dave Peterson" wrote:

Do all your work (including sharing the workbook).
Save that workbook
Close that workbook
Reopen that workbook (it still should be shared)
Try filtering the data.

Does it work?

What version of excel are you using?

JP wrote:

Dave can you explain further? I tested my method and it worked. As
long as you apply the autofilter first, then allow autofilter to be
used when protecting the workbook, it should allow you to use the
filter dropdowns after you share the workbook. Maybe it works because
I am doing it by hand instead of programmatically?

Thx,
JP

On Nov 15, 7:37 am, Dave Peterson wrote:
But you can't change the protection status of any worksheet in a shared
workbook.

And since that userinterfaceonly setting is forgotten after you close the file,
the code needs to be rerun each time the workbook opens. And if the workbook is
shared, the code will fail.





JP wrote:

You just have to follow the steps in the correct order, refer to my
earlier post.


--

Dave Peterson


--

Dave Peterson