Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Printing while a userform is active

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.







  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •