I have inherited an application which has a print button on it with an action to print sheet.
When this button is pressed it takes me to a new tab which has the printable version of the charts on it e.g. just the charts with no selection criteria boxes or text.
I would like this tab to be hidden so users cannot see it but when they click the print button it the tab is activated and they can print the printable view.
When I conditionally hide the printable sheet and press the print button it prints the active sheet which has the selection boxes and text etc on it.
Is there any way to set up the print button so that the printable sheet is hidden but prints when the button I'd pressed?
