Dibbley247
04-18-2013, 01:56 PM
Is there a macro which will call up the print window for a specific chart.
I currently have a macro for each graph. But due to default settings in work, the printers are back and white. Also the sheets are protected so the macro at the moment unprotects the sheet selects the relevant chart, prints, then price ya again.
I'd like to press the button for "chart1" the print window to appear, user can then press print to carry on, or go to settings and change to colour if required.
And then somehow protects the sheet again.
Thanks
I currently have a macro for each graph. But due to default settings in work, the printers are back and white. Also the sheets are protected so the macro at the moment unprotects the sheet selects the relevant chart, prints, then price ya again.
I'd like to press the button for "chart1" the print window to appear, user can then press print to carry on, or go to settings and change to colour if required.
And then somehow protects the sheet again.
Thanks