Use existing macro to create another macro
 

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 fileprint but it would look better if I could
just have a button to press.

Thanks in advance.

Use existing macro to create another macro
 

See Chip's page at http://www.cpearson.com/excel/vbe.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"fullers" wrote in message
...
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 fileprint but it would look better if I could
just have a button to press.

Thanks in advance.