Hi
Is there a VBA command to deselect all items of RowField or ColumnField at
one rather than making the visible property of each item to false?
I have like 35 different items and it may vary and i only want 6 of them.
Thanks
Hi
Is there a VBA command to deselect all items of RowField or ColumnField at
one rather than making the visible property of each item to false?
I have like 35 different items and it may vary and i only want 6 of them.
Thanks
There's sample code here for showing and hiding items:
http://www.contextures.com/xlPivot03.html
Keyur wrote:
> Hi
>
> Is there a VBA command to deselect all items of RowField or ColumnField at
> one rather than making the visible property of each item to false?
>
> I have like 35 different items and it may vary and i only want 6 of them.
>
> Thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Thanks Debra.
"Debra Dalgleish" wrote:
> There's sample code here for showing and hiding items:
>
> http://www.contextures.com/xlPivot03.html
>
> Keyur wrote:
> > Hi
> >
> > Is there a VBA command to deselect all items of RowField or ColumnField at
> > one rather than making the visible property of each item to false?
> >
> > I have like 35 different items and it may vary and i only want 6 of them.
> >
> > Thanks
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks