Macro to print chart

[Dibbley247]

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

[Trebor76]

Hi Dibbley247,

Try adding this line after the chart has been selected (not normally necessary but I think here it is) and unprotected...


Application.Dialogs(xlDialogPrint).Show

...followed by your code to reprotect the tab.

HTH

Robert