Sheet Background Color ( issue on property > UseColorBkg )

[#1]

Hi all,

i'm working on a macro that set up Sheet Background Color with gradients ( QlikView 9.SR5 Desktop x64)

My macro DOES apply all the parameters ( such as Primary and Secondary Color, Gradient Type, etc ) but it seems that property UseColorBkg isn't recognized : i need to activate sheet background color settings by hand after macro execution.

Any idea ? What am i doing wrong?

Cheers,

Fabrizio

Sub SetBackgroundCol(SheetId)

set vSheet = ActiveDocument.GetSheetById(SheetId)

set vSheetProp = vSheet.GetProperties

vSheetProp.BkgColor.Mode = 2

vSheetProp.BkgColor.PrimaryCol.Col = RGB(88,143,254)

vSheetProp.BkgColor.SecondaryCol.Col = RGB(128,143,254)

vSheetProp.BkgColor.FillDirection = 0

vSheetProp.BkgColor.FillPattern = 0

vSheetProp.UseColorBkg = true

vSheet.SetProperties vSheetProp

end sub

[#2 · Accepted solution]

Hi,

I believe you also need to explicitly state that you do not want to use the document defaults for the background.

Try adding the following line to your macro -

vSheetProp.UseApplicationBkg = false

I hope this helps

Thanks

Nick

[#3]

Nick!

* * * G R E A T * * * * *

Thank you so much! It works perfectly!!

You have avoided me a BIG embarrassment!

Best regards,

Fabrizio