How do I enable autofilter on a protected shared workbook?
 

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?

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.

Bungle wrote:

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?

--

Dave Peterson

Cheers Dave,

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

"Dave Peterson" wrote:

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.

Bungle wrote:

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?

--

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.



Bungle wrote:

Cheers Dave,

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

"Dave Peterson" wrote:

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.

Bungle wrote:

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?

--

Dave Peterson


--

Dave Peterson