Printing while a userform is active

T · Apr 3rd, 2002, 12:49 AM

I have a userform which acts as an interface for database information contained in Sheet 1.

On the userform I have a Print button which copies the currently displayed record to a Print Template in Sheet 3 and brings up the standard Print Preview screen

I want the user to be able to print off the sheet and then return to the userform.

Since the user form is open the Excel Print Preview buttons are disabled. How can I enable the options on Print Preview to work and allow printing and then return control back to the user form?

Any help would be greatly appreciated. t.

Dave Hawley · Apr 3rd, 2002, 01:07 AM

Hi T

The easiest way would be to have Excel 2000 then you can set the ShowModal Property to False at Design-time. Then the user could shift focus back to Excel just by clicking.

The other option you have is:

1. Use Me.Hide before doing the print-set-up then have a button that would re-show the UserForm, ie Userform1.Show This could be done by assigning your UserForm.Show code to a Shortcut key and displaying a simple message telling them the keys to show the form again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 12:49 AM	#1
T New Member Join Date: Apr 2002 Posts: 25	I have a userform which acts as an interface for database information contained in Sheet 1. On the userform I have a Print button which copies the currently displayed record to a Print Template in Sheet 3 and brings up the standard Print Preview screen I want the user to be able to print off the sheet and then return to the userform. Since the user form is open the Excel Print Preview buttons are disabled. How can I enable the options on Print Preview to work and allow printing and then return control back to the user form? Any help would be greatly appreciated. t.

Apr 3rd, 2002, 01:07 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi T The easiest way would be to have Excel 2000 then you can set the ShowModal Property to False at Design-time. Then the user could shift focus back to Excel just by clicking. The other option you have is: 1. Use Me.Hide before doing the print-set-up then have a button that would re-show the UserForm, ie Userform1.Show This could be done by assigning your UserForm.Show code to a Shortcut key and displaying a simple message telling them the keys to show the form again.