SiddersAtCHEP
Board Regular
- Joined
- Nov 2, 2005
- Messages
- 104
Can anyone help with this?
I have a macro which populates a pivot table. When it does this, despite my having set
ActiveWorkbook.ShowPivotTableFieldList = False
before
ActiveSheet.PivotTables("PivotTable1").SourceData = "MyFile!R" & MyTopLine & "C1:R" & MyBottomLine & "C52"
It still flashes up with the Field List. I can close it down again immediately but I am trying to get it so that the users never have to see it as it will only confuse them...seriously.
Is there any way of stopping it from showing entirely?
Many thanks
Sidders
I have a macro which populates a pivot table. When it does this, despite my having set
ActiveWorkbook.ShowPivotTableFieldList = False
before
ActiveSheet.PivotTables("PivotTable1").SourceData = "MyFile!R" & MyTopLine & "C1:R" & MyBottomLine & "C52"
It still flashes up with the Field List. I can close it down again immediately but I am trying to get it so that the users never have to see it as it will only confuse them...seriously.
Is there any way of stopping it from showing entirely?
Many thanks
Sidders