ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display HTML help file using FollowHyperlink; want browser to have Focus (https://www.excelbanter.com/excel-programming/300660-display-html-help-file-using-followhyperlink%3B-want-browser-have-focus.html)

L Mehl

Display HTML help file using FollowHyperlink; want browser to have Focus
 
Hello --

We display the HTML help file using

ThisWorkbook.FollowHyperlink _
Address:="c:\TAHelp.htm"

It opens a browser window containing the file, but the browser loses focus,
so the user has to click the browser icon in the tray to give it focus.

Is there a parameter to set to open the browser and give it the focus?

I am thinking of vbMaximizedFocus in a Shell command which has this effect.

From a broader perspective, is FollowHyperlink the best way to open a Help
file?

Thanks for any suggestions.

Larry Mehl



Dick Kusleika[_3_]

Display HTML help file using FollowHyperlink; want browser to have Focus
 
Larry

How are you running the sub? For me XL2000 and Mozilla FireFox, it gets the
focus.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"L Mehl" wrote in message
...
Hello --

We display the HTML help file using

ThisWorkbook.FollowHyperlink _
Address:="c:\TAHelp.htm"

It opens a browser window containing the file, but the browser loses

focus,
so the user has to click the browser icon in the tray to give it focus.

Is there a parameter to set to open the browser and give it the focus?

I am thinking of vbMaximizedFocus in a Shell command which has this

effect.

From a broader perspective, is FollowHyperlink the best way to open a Help
file?

Thanks for any suggestions.

Larry Mehl





keepITcool

Display HTML help file using FollowHyperlink; want browser to have Focus
 
could it be window XP setting: Prevent Window stealing focus?

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Dick Kusleika" wrote:

Larry

How are you running the sub? For me XL2000 and Mozilla FireFox, it
gets the focus.



L Mehl

Display HTML help file using FollowHyperlink; want browser to have Focus
 
Dick --

It runs on a button click. FireFox is OK for me, too.

Larry

"Dick Kusleika" wrote in message
...
Larry

How are you running the sub? For me XL2000 and Mozilla FireFox, it gets

the
focus.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"L Mehl" wrote in message
...
Hello --

We display the HTML help file using

ThisWorkbook.FollowHyperlink _
Address:="c:\TAHelp.htm"

It opens a browser window containing the file, but the browser loses

focus,
so the user has to click the browser icon in the tray to give it focus.

Is there a parameter to set to open the browser and give it the focus?

I am thinking of vbMaximizedFocus in a Shell command which has this

effect.

From a broader perspective, is FollowHyperlink the best way to open a

Help
file?

Thanks for any suggestions.

Larry Mehl







L Mehl

Display HTML help file using FollowHyperlink; want browser to have Focus
 
I will check into that setting, for the XP users.

Larry

"keepitcool" wrote in message
...
could it be window XP setting: Prevent Window stealing focus?

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Dick Kusleika" wrote:

Larry

How are you running the sub? For me XL2000 and Mozilla FireFox, it
gets the focus.






All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com