Thread: Pivot Table Deselect all items
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Keyur Keyur is offline
external usenet poster
  
Posts: 2
Default Pivot Table Deselect all items
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


Reply With QuoteReply With Quote