View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
IanC IanC is offline
external usenet poster
 
Posts: 49
Default Controlling dialog programatically

Hi Bob,

Thanks for the quick response. Unfortunately, I am still getting the same
problem - when the system shows the second user form it just waits for the
user to click a button on the User Form before proceeding with the print.

I cannot see how to initiate the second (and subsequent) prints without user
intervention.

"Bob Phillips" wrote:

Don't unload it, hide it, it will then still be part of the forms collection

--
HTH

Bob Phillips

"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.