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