copy Before_print code into new workbook

[rhodevans]

Afternoon,

I have a piece of code that copies a worksheet and puts it in a new workbook, then save it under it's own filename. See Below:

Please Login or Register  to view this content.

The issue is I want the code that is in the Workbook before_print event to be copied as well. I suppose the the three questions are:

Is this possible?
How do you do it?
If not is there a way to approximate the function of running code before a worksheet is printed?

I cannot seem to see anything on the internet about this, so I'm not even sure if it's possible. So any help would be much appreciated.

Thanks in advance

Rhod

[Norie]

Rhod

1 Yes.

2 By writing code that writes code, which would require allowing access to the VBA project which may be a security issue.

3 Not sure what you mean by that.

Have you considered using a template workbook that has the code for workbook BeforePrint in it?

If you used a template you could create a new workbook from it and then copy the worksheet into it.

Please Login or Register  to view this content.

[Richard Buttrey]

Hello Rhod,

Why don't you use another approach and instead of adding a new workbook and copying a sheet into it, use Workbook.SaveAs to save the whole of the current workbook and then delete any sheets in the copied workbook that you don't want to be present.

[rhodevans]

Both of those idea's sound as if they could work quite well, so i will have a look and see which works best. Thanks very much for both your help. i will let you know!!