Does anyone know if it is possible to use autofilter on a hidden worksheet. I
know that as a workaround I can make it visible, do the do, and then make it
hidden again, but out of curiosity I wondered whether this is some sort of
restriction??

We've tried several methods without any success.

Any help greatly appreciated

You can filter on a hidden sheet but not a protected one unless you allow
filtering. What methods have you tried?

--

Regards,
Nigel
(E-Mail Removed)



"JLR-Mart" <(E-Mail Removed)> wrote in message
news:C2A4658C-22E2-4965-93C1-(E-Mail Removed)...
> Does anyone know if it is possible to use autofilter on a hidden
> worksheet. I
> know that as a workaround I can make it visible, do the do, and then make
> it
> hidden again, but out of curiosity I wondered whether this is some sort of
> restriction??
>
> We've tried several methods without any success.
>
> Any help greatly appreciated

Our code looks something like this:

Worksheets("BPNO_CPSCII").Activate
Range("A1:G1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="<>*" & CPSC & "*"

BUT when it runs it filters the currently visible sheet and NOT the hidden
one (BPNO_CPSCII) as required

"Nigel" wrote:

> You can filter on a hidden sheet but not a protected one unless you allow
> filtering. What methods have you tried?
>
> --
>
> Regards,
> Nigel
> (E-Mail Removed)
>
>
>
> "JLR-Mart" <(E-Mail Removed)> wrote in message
> news:C2A4658C-22E2-4965-93C1-(E-Mail Removed)...
> > Does anyone know if it is possible to use autofilter on a hidden
> > worksheet. I
> > know that as a workaround I can make it visible, do the do, and then make
> > it
> > hidden again, but out of curiosity I wondered whether this is some sort of
> > restriction??
> >
> > We've tried several methods without any success.
> >
> > Any help greatly appreciated
>
>

Yes but you cannot activate a hidden sheet.

Change your code to

With Worksheets("BPNO_CPSCII").Range("A1:G1")
.AutoFilter
.AutoFilter Field:=1, Criteria1:="<>*" & CPSC & "*"
End With


In general you never need to select before acting on a worksheet or its
objects.

--

Regards,
Nigel
(E-Mail Removed)



"JLR-Mart" <(E-Mail Removed)> wrote in message
news:285205A9-3A8F-4DD9-95F8-(E-Mail Removed)...
> Our code looks something like this:
>
> Worksheets("BPNO_CPSCII").Activate
> Range("A1:G1").Select
> Selection.AutoFilter
> Selection.AutoFilter Field:=1, Criteria1:="<>*" & CPSC & "*"
>
> BUT when it runs it filters the currently visible sheet and NOT the hidden
> one (BPNO_CPSCII) as required
>
> "Nigel" wrote:
>
>> You can filter on a hidden sheet but not a protected one unless you allow
>> filtering. What methods have you tried?
>>
>> --
>>
>> Regards,
>> Nigel
>> (E-Mail Removed)
>>
>>
>>
>> "JLR-Mart" <(E-Mail Removed)> wrote in message
>> news:C2A4658C-22E2-4965-93C1-(E-Mail Removed)...
>> > Does anyone know if it is possible to use autofilter on a hidden
>> > worksheet. I
>> > know that as a workaround I can make it visible, do the do, and then
>> > make
>> > it
>> > hidden again, but out of curiosity I wondered whether this is some sort
>> > of
>> > restriction??
>> >
>> > We've tried several methods without any success.
>> >
>> > Any help greatly appreciated
>>
>>

You can't activate a hidden sheet. But the good thing is that you don't need
to.

with Worksheets("BPNO_CPSCII")
.autofiltermode = false 'remove any existing filter.
.Range("A1:G1").AutoFilter Field:=1, Criteria1:="<>*" & CPSC & "*"
end with

JLR-Mart wrote:
>
> Our code looks something like this:
>
> Worksheets("BPNO_CPSCII").Activate
> Range("A1:G1").Select
> Selection.AutoFilter
> Selection.AutoFilter Field:=1, Criteria1:="<>*" & CPSC & "*"
>
> BUT when it runs it filters the currently visible sheet and NOT the hidden
> one (BPNO_CPSCII) as required
>
> "Nigel" wrote:
>
> > You can filter on a hidden sheet but not a protected one unless you allow
> > filtering. What methods have you tried?
> >
> > --
> >
> > Regards,
> > Nigel
> > (E-Mail Removed)
> >
> >
> >
> > "JLR-Mart" <(E-Mail Removed)> wrote in message
> > news:C2A4658C-22E2-4965-93C1-(E-Mail Removed)...
> > > Does anyone know if it is possible to use autofilter on a hidden
> > > worksheet. I
> > > know that as a workaround I can make it visible, do the do, and then make
> > > it
> > > hidden again, but out of curiosity I wondered whether this is some sort of
> > > restriction??
> > >
> > > We've tried several methods without any success.
> > >
> > > Any help greatly appreciated
> >
> >

--

Dave Peterson