Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Userform hides by itself

Hi Community !

I have a .xls file in the Server of my company. And many people access it.
In a multipage, when people select page 6, another .xls file from server is
activated but when this one is activated, the Userform hides by itself.
The user must use ALT + TAB to get the Userform back to screen.

BUT...

It happens only in a few computers, because of bad connection I think
(wireless connection).

Is there any command I can use for both cases?
- If Userform is activated the command won't bug the file.
- If Userform is hidden, the command will bring it to screen

Thank you !
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default Userform hides by itself

it sounds like its an issue with the monitor and refresh. When the new
workbook is opened, it becomes the active application and the monitor driver
with put it in "front " of other applications....and this will hide the form.
the form doesn't hide itself. when the next refresh cycle occurs, the
userform, as part of the active application, will again be brought to the
front.
I've seen this before - and in those cases there have been a either a lot of
applications running or a few applications running but which have frequent
updates. our solution was faster screens with greater bandwidth.


"Eddie_SP" wrote:

Hi Community !

I have a .xls file in the Server of my company. And many people access it.
In a multipage, when people select page 6, another .xls file from server is
activated but when this one is activated, the Userform hides by itself.
The user must use ALT + TAB to get the Userform back to screen.

BUT...

It happens only in a few computers, because of bad connection I think
(wireless connection).

Is there any command I can use for both cases?
- If Userform is activated the command won't bug the file.
- If Userform is hidden, the command will bring it to screen

Thank you !

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
Autofilter Hides All... TomCat Excel Worksheet Functions 1 June 8th 09 12:43 PM
Filtering data hides row John[_140_] Excel Programming 3 May 25th 09 05:30 PM
code to hide hides too much Marilyn Excel Discussion (Misc queries) 4 January 25th 08 02:46 AM
Open workbook hides [email protected] Excel Discussion (Misc queries) 3 May 28th 06 08:47 PM
Autofilter hides totals I want to see Mark Excel Programming 4 November 3rd 03 08:18 PM


All times are GMT +1. The time now is 06:42 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"