Color Properties

[Diego]

Hi!
i used to have the next instructions

view.HeaderBackColor = "Gold"
oDimension1.Fields(0).GroupedBackColor = "MidnightBlue"
oDimension1.Fields
(0).GroupedFont.Color = "Lavender"

and they work fine, now they are giving me errors

any idea?

thanks

 

[Dip]

Hi,
Have you done this way;
------
----
Dim ptConstants

Set ptConstants = PivotTable.Constants

With PivotTable.ActiveView

.FieldLabelBackColor = "LightSeaGreen"
.TotalBackColor = "White"
.HeaderBackColor = "Gold"
-------------------------------
-------------------------------
------------------------------
.RowAxis.FieldSets( sDimStream1
).Fields(0).GroupedBackColor = "MidnightBlue"
.RowAxis.FieldSets( sDimStream1
).Fields(0).GroupedFont.Color = "Lavender"

-------------------
I have done this way and it's working without any trouble.
sDimStream1 is my Dimension name stored in a CONST Global variable.
What kind of error you getting anyway?

Cheers.
Dip