Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheet Background Color ( issue on property > UseColorBkg )

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





1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Not applicable
Author

Nick!

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

Thank you so much! It works perfectly!!

You have avoided me a BIG embarrassment!

Best regards,

Fabrizio