Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Third Time Posting this Question: Hyperlink Problem
Hi Seth,
It works for me when I try it (XL 2002, Win XP). I basically set up a subroutine like this: Sub test() UserForm1.Show End Sub I placed a Label on UserForm1 (named the Label lblHyperlink), set its caption to www.totalflood.com, and set its font to blue and underlined. The Click event of the Label looks like this: Private Sub lblHyperlink_Click() ThisWorkbook.FollowHyperlink "http://www.totalflood.com" End Sub When I run test, the UserForm is displayed. When I click the link, IE opens up and navigates to the site as expected. I am able to switch back and forth between IE and Excel with no problems. However, if I used Application.ScreenUpdating=False before I showed the UserForm, it caused all sorts of screen refresh issues, which may be what you're seeing. So make sure ScreenUpdating=True before you show your form. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Seth wrote: I have a hyperlink in a Userform. It works fine to take the user to the webpage, but the workbbok that I am working in will not open back up. I know that excel is still open because it is still minimized. When I click on it, nothing happens. The way that I have to get the workbbook to open back up is to double click on the file. When I do this, Excel maximizes and the workbook is in the exact spot that I left it before clicking on the hyperlink (with the userform showing). Here is the code that I use: ThisWorkbook.FollowHyperlink Address:="http://www.totalflood.com" Seth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Third Time Posting this Question: Hyperlink Problem
Jake
Thanks for the help. I put the "ScreenUpdating = True" into the code and it is working now. I appreciate the help Seth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink problem and question | New Users to Excel | |||
Posting problem | Excel Worksheet Functions | |||
posting problem | Excel Worksheet Functions | |||
Problem Posting Replies | Excel Discussion (Misc queries) | |||
Posting problem? | Excel Discussion (Misc queries) |