I have a worksheet that has 25 or so separate tabs. On each tab is both a Report section, and 3 or so Charts. The combination of the report section and the 3 or so charts on each sheet is a 'printed page'.
I have a need to print or suppress the Chart portion ...... and yet I also need to be able to NOT suppress it.
Right now, I am planning to hide the charts using a range name, and then running a macro to apply to each sheet.
My other thought was to use different print ranges.
Is there a better way to suppress the charts? I'd love to be able to suppress them based on a single cell value.
Thanks in advance.
Bookmarks