Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Bring up a UserForm to the front

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Bring up a UserForm to the front

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


"Jens 'Kluesi' Kluesener" wrote in message
...
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



Reply
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
Overrighting ( bring to front) dpal Excel Discussion (Misc queries) 1 September 24th 09 10:49 PM
Bring to Front Chuck Excel Discussion (Misc queries) 0 November 8th 06 04:50 PM
Bring series to front coa01gsb Charts and Charting in Excel 1 March 21st 06 06:39 PM
How do I bring a certain data series to the front Adam P. Charts and Charting in Excel 1 January 3rd 06 08:36 PM
"Bring to Front" Data Labels? Rob Charts and Charting in Excel 2 April 3rd 05 04:59 PM


All times are GMT +1. The time now is 02:15 PM.

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

About Us

"It's about Microsoft Excel"