Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a button that prints a sheet while hiding several items that don't need to be printed. It works fine. However, the sheet has a background image that will not print when using this button. If I right click within the sheet and select print, the background image prints fine but it also prints everything I don't want printed.
The background image won't print even if I delete all the code out of the macro except
ActiveDocument.ActiveSheet.Print
Any Ideas? Is there another way to print the sheet via a macro?
Hi,
We have the Inbuilt Macro in the Qlikview in the Action Tab.
Create a Button and go the Actions add aPrint Sheet action,give the sheetid and then enable the Print with Background Option.its available in QV 10.Let you check once if ur using othar than this version.
Regards,
Santhosh Kumar G
Print has an optional parameter for print background, try:
ActiveDocument.ActiveSheet.Print true