How do I enable autofilter on a protected shared workbook?

B

Bungle

How do I do this in Excel 2000? I can get autofilter working in a protected
sheet using a vbr code, but can't get this autofilter working in a protected
shared workbook. Anyone know how to resolve this?
 
D

Dave Peterson

The bad news is that you want to change the protection of a worksheet with
something like:

With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableAutoFilter = True
End With

But you can't change worksheet protection in a shared workbook.

I think you'll have to make a choice--shared or filters.
 
B

Bungle

Cheers Dave,

I kind of thought that that may be the case. It does seem a little stupid
though doesn't it?!
 
D

Dave Peterson

There are a lot of features that are disabled with shared workbooks.

I'm not sure if anyone (outside of MS) actually knows why they didn't choose to
enable some.
 
Top