Macro to print sheet

[dahouse]

I need to create a print macro that will print a designated sheet from a workbook. I also need one to print the entire workbook. I'm going to put shapes on the summary with print commands so the managers can actually print what they need instead of bothering me.

[Trebor76]

Hi there,

Use the following to print the workbook...

Please Login or Register  to view this content.

...and the following to print Sheet1 (change to suit):

Please Login or Register  to view this content.

HTH

Robert