Bring up a UserForm to the front

  • Thread starter Jens 'Kluesi' Kluesener
  • Start date
J

Jens 'Kluesi' Kluesener

Hi

I create a word document from Excel. If I do this whil word is running my
form is on the top of the screen. If word is not running the form is not at
the top of the screen when word starts. How can I now bring up the form to
the front?

Many Thanks

Jens
 
H

Henry

Jens,

Some code would have been helpful.
I've looked again at the code in your website and suggest you try putting
the
..Visible = True before the .ScreenUpdating = False line

The way you've got it, you turn off screen updating and then try to make
word visible.
As the screen updating is turned off, this has no (visible) effect until you
turn screen updating on again.

With appWord.Application
.Visible = True
If CHECK Then .ScreenUpdating = True Else .ScreenUpdating = False

HTH
Henry
 
Top