Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent closing userform
In a userform I have a button to some HTML helppages. I use this code:
Link = Range("Test!B28").Value On Error GoTo Nocando ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True Unload Me Exit Sub Nocando: MsgBox "Cannot find" & Link start.Show But: the userform closes also with this action. How can I prevent that? Regards, Gert-Jan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent closing userform
Try commenting out the Unload Me line (the culprit)
"Gert-Jan" wrote in message : In a userform I have a button to some HTML helppages. I use this code: Link = Range("Test!B28").Value On Error GoTo Nocando ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True Unload Me Exit Sub Nocando: MsgBox "Cannot find" & Link start.Show But: the userform closes also with this action. How can I prevent that? Regards, Gert-Jan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent closing userform | Excel Programming | |||
How do I prevent all excel applications from closing at once? | Excel Discussion (Misc queries) | |||
Prevent DialogBox closing | Excel Programming | |||
Prevent workbook closing... | Excel Programming | |||
API to prevent closing Excel | Excel Programming |