LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Controlling dialog programatically

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete the "Insert Function Dialog Box" (dialog box only)? TBI''d biker Excel Worksheet Functions 2 April 7th 07 09:18 PM
programatically creating dialog box [email protected] Excel Programming 1 March 20th 05 10:51 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
Programatically set ref to my DLL ricks Excel Programming 2 April 13th 04 03:08 PM
Controlling VBA MWE[_3_] Excel Programming 2 January 13th 04 07:23 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"