How does that work?

I am all very new to this Pike and only understand little bits. Probably why this is so hard for me.

When you say append how will that work? Th assigning of the macro is only in module 2 as this is to relate to the new workbooks formed each time only.

So the new workbook is formed, module 2 transferred and the macro within module 2 NewPrint assigned to the print button on sheet one, saved as whatever the user wishes and closed.

Then at a later date the user may go back into this spreadsheet to amend a cost they got wrong or something, then I want this to be saved separately but the details to go on to original sheet which will be saved on each users computer, unfortunately I will not know where.

Have I lost you? I'm a bit confused myself now.