Ideally, they would not all bel oaded and in view at the same time - although
if that were to be what it takes, it would not be a problem. All four Forms
have their own PRINT button that prints that Form alone. I was planning to
put a PRINT ALL button just on the first Form.

Hope this clarifies - many thanks for your interest.



"William Benson" wrote:

Can you clarify one thing?Will all four forms will be loaded and in view at
the same time, prior to printing? I have tried to open two userforms at the
same time, either with external code or by trying to make one form show the
other (using FRM2.Show somewhere in the code module of FRM1) and it didn't
work.

Will one of the forms have "THE" Print button? So in clicking the Print
button on Form 1, it is supposed to Print itself and the other three? -- or
will "THE" Print button be on a worksheet?




"IanC" wrote in message
...
I have a programme that contains 4 User Forms, all of which display data.
I
can print them individually by means of a macro connected to a button
(PRINT)
on each user form. However, I cannot make all of them print from a single
click.

The problem is that the first user form will print, but when I unload that
and then show the next form, the system sits there waiting for the user to
click a button on that new form.

Is there any way that I can instruct the system to print each user form in
turn (i.e. the equivalent of the user pressing the PRINT) and then proceed
onto the next user form, without the need for user intervention.