I want to create a button that will change my background in the sheet.
I wrote that code:
status = ActiveDocument.Sheets(4).SetWallPaper ("image", 2)
But after that Qlik change image formatting to 'Fill'. I want to set 'Keep Acpect'.
How can I do that?
Have a look on this example from APIGuide.qvw (in your install-folder):
sp.BkgImageSettings.ImageStyle.StretchMode = 1 'fill
0 = No Stretch
1 = Fill
2 = Keep Aspect
3 = Fill with Aspect
4 = Tile