| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file browser window | Excel Discussion (Misc queries) | |||
| HTML HREF Opening in Browser | Excel Programming | |||
| Keep Object with Focus on Display Screen | Excel Programming | |||
| FollowHyperlink then Save File | Excel Programming | |||
| display in memory data in browser window | Excel Programming | |||
Linear Mode
