Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Window Corrupted After Print Preview (2000)

    In my Userform, a button click will bring up a print preview of some selected sheets.

    However, after closing the print preview, I wish to return control to the UserForm. The UserForm opens fine, but behind it I wish to view the main worksheet ("Main"). It seems to return control to the UserForm but in the background, Excel has not updated the screen, as there are parts of the print preview behind it. When you move the UserForm around, it leaves shadows of itself. After closing the UserForm all is well.

    Does anybody know what I'm talking about?

    Welcome.Hide
    ActiveWorkbook.PrintOut Copies:=1, Collate:=True, Preview:=True
    Welcome.Show

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Window Corrupted After Print Preview (2000)

    Nevermind, I just forgot to re-activate screen updating after having turned it off!

Posting Permissions

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