| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I set PivotItem.Visible property to True?
What's wrong with the following codes? I can set visible=false but when I try to set it to true run I receive run time error
at "pi.visible = True" Dim pi as pivotitem sheets("pivot").select For Each pi in ActiveSheet.PivotTables("Pivottable1").PivotFields ("fieldname").PivotItems If pi.Visible = False Then pi.Visible = True End If Next |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I set PivotItem.Visible property to True?
(correction!)Please ignore 'run' after 'set it to true'....
Any help would be appreciated! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I set PivotItem.Visible property to True?
Problem is solved. Thanks for Debra D.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does a HasDependents = True property exist? | Excel Discussion (Misc queries) | |||
| Windows Visible Property - Code Help | Excel Discussion (Misc queries) | |||
| Visible property on Worksheets | Excel Programming | |||
| Visible Property | Excel Programming | |||
| .Visible Property | Excel Programming | |||
Linear Mode
