Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel stealing focus

Hi all,

I've searched far and wide for this for the past 2 months (off and on) and
have yet to find a logical answer/solution.

The problem, as far as I can tell, arises from having a lot of data being
refreshed at a fairly high rate (real time stock data, etc). I have Excel
with automatic calculation, and I have set up TweakUI properly to disallow
the stealing of focus.

Here are some odds and ends to this problem. Excel will only steal focus
from another Office application if and only if you click on the office
application while Excel is in focus. This means that if Excel is in focus,
then you click on a Non-Office app, then click on Outlook, Excel will not
steal focus. It is very peculiar and very repeatable at all the computers
here, and it is quite annoying because Excel will steal focus from another
Excel or Outlook every 1/2 second to 1 second and makes switching between
applications a real nuisance.

I will give more details as I find them.

Has anyone seen this before? Or have any idea how to work around it?

Thanks,
Akshay


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 109
Default Excel stealing focus

Can you set the Application.visible property to False with code?


Regards
BrianB
=====================================

"Akshay" wrote in message ...
Hi all,

I've searched far and wide for this for the past 2 months (off and on) and
have yet to find a logical answer/solution.

The problem, as far as I can tell, arises from having a lot of data being
refreshed at a fairly high rate (real time stock data, etc). I have Excel
with automatic calculation, and I have set up TweakUI properly to disallow
the stealing of focus.

Here are some odds and ends to this problem. Excel will only steal focus
from another Office application if and only if you click on the office
application while Excel is in focus. This means that if Excel is in focus,
then you click on a Non-Office app, then click on Outlook, Excel will not
steal focus. It is very peculiar and very repeatable at all the computers
here, and it is quite annoying because Excel will steal focus from another
Excel or Outlook every 1/2 second to 1 second and makes switching between
applications a real nuisance.

I will give more details as I find them.

Has anyone seen this before? Or have any idea how to work around it?

Thanks,
Akshay

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel stealing focus

"BrianB" wrote in message
om...
Can you set the Application.visible property to False with code?


I don't want the application to be hidden. Most of us use 2 monitors, and
some have 3 and 4. We also like to view several spreadsheets at the same
time, which is the ultimate goal, so making it hidden is not really an
option. I also thought about turning automatic calculations to manual when
the application looses focus, but I seem to be having trouble catching that
event, and that also is not the prefered solution (albeit temporary would
suffice for now)

-akshay

=====================================

"Akshay" wrote in message

...
Hi all,

I've searched far and wide for this for the past 2 months (off and on)

and
have yet to find a logical answer/solution.

The problem, as far as I can tell, arises from having a lot of data

being
refreshed at a fairly high rate (real time stock data, etc). I have

Excel
with automatic calculation, and I have set up TweakUI properly to

disallow
the stealing of focus.

Here are some odds and ends to this problem. Excel will only steal focus
from another Office application if and only if you click on the office
application while Excel is in focus. This means that if Excel is in

focus,
then you click on a Non-Office app, then click on Outlook, Excel will

not
steal focus. It is very peculiar and very repeatable at all the

computers
here, and it is quite annoying because Excel will steal focus from

another
Excel or Outlook every 1/2 second to 1 second and makes switching

between
applications a real nuisance.

I will give more details as I find them.

Has anyone seen this before? Or have any idea how to work around it?

Thanks,
Akshay



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel stealing focus

I have found more information on this problem. It's been confirmed that this
happens by other people in other companies, and they've noted that this only
occurs in Office XP. 2000 works just fine and doesn't cause problems.

I really hope that someone from MSFT is reading this, because this has got
to be one of the most annoying bugs ever!

-akshay

"Akshay" wrote in message
...
Hi all,

I've searched far and wide for this for the past 2 months (off and on) and
have yet to find a logical answer/solution.

The problem, as far as I can tell, arises from having a lot of data being
refreshed at a fairly high rate (real time stock data, etc). I have Excel
with automatic calculation, and I have set up TweakUI properly to disallow
the stealing of focus.

Here are some odds and ends to this problem. Excel will only steal focus
from another Office application if and only if you click on the office
application while Excel is in focus. This means that if Excel is in focus,
then you click on a Non-Office app, then click on Outlook, Excel will not
steal focus. It is very peculiar and very repeatable at all the computers
here, and it is quite annoying because Excel will steal focus from another
Excel or Outlook every 1/2 second to 1 second and makes switching between
applications a real nuisance.

I will give more details as I find them.

Has anyone seen this before? Or have any idea how to work around it?

Thanks,
Akshay




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
cursor focus in excel fourthhorn Excel Discussion (Misc queries) 1 June 2nd 06 06:05 AM
Excel 2003 Toolbar Icons are fuzzy and out of focus Jimmer Excel Discussion (Misc queries) 3 February 14th 06 01:42 PM
How do I get focus back on an Excel file? Stumpiana Charts and Charting in Excel 1 November 18th 05 01:21 AM
Why are my inserted photos out of focus when I open excel? lakrueger Excel Discussion (Misc queries) 0 September 23rd 05 11:07 PM
Excel 97 VBA: Multipage set focus method David Excel Programming 3 October 7th 03 01:55 PM


All times are GMT +1. The time now is 09:45 AM.

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"