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.