In my job I create financial reports that will ultimately be sent to my
partners.

In the excel file I have there is internal data that I do not want the
partner to see. I have created a macro that will copy over the pages that are
fine to go out to them into a new workbook.

What I was wondering is if it is possible that once this new workbook is
created that I can have it add a seperate macro to this work book that will
print all the pages?

I realise I could just use >file>print but it would look better if I could
just have a button to press.

Thanks in advance.