Hide PivotItem in Excel XP

  • Thread starter Jos? Luis Paz Vidal via OfficeKB.com
  • Start date
J

Jos? Luis Paz Vidal via OfficeKB.com

In Excel 97 in Spanish I hidden a PivotItems with the next command in VBA

..PivotItems("(vac?as)").Visible = False

and when I try to do the same in Excel XP in English I get a error.

How I can change the sintax for Excel XP in English ?

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete selection in pivotcolumn 3
VBA Pivot Table: Determining item from one field based on anotherfield item 0
VBA, Macros and Pivot Tables 1
Controlling Pivotitems.visible 0
Change report firlds in pivot tables and charts with one selection 0
Pivot Table - How do I "Show All Data" of a particular field? 6
How to cycle through displayed PivotItems instead of the VisibleItemscollection 2
change/set pivot table autofilter criteria with macro button 3

Top