lost focus ???

jeffh · May 24th, 2002, 03:23 AM

Hi,
I have a form which is used as a custom 'front end' for an excel sheet which contains data and hyperlinks to local files.
When the hyperlinks are activated using the follow command eg
Excel.Worksheets("sheet1").Cells(lookup, 1).Hyperlinks.Item(1).Follow this all works fine except when the target file opens in a new application eg adobe reader, excel is minimized to the taskbar, and wont restore to it's normall size when the taskbar icon is cklicked. Does anyone have any ideas on how to restore the excel window.
thanks
jeff

jeffh · May 24th, 2002, 04:06 AM

I've worked out a solution...Think it might be a bit of a bodge but it works reliably.
thanks to colo for his advice on minimimzing workbooks.
If the workbook is minimized:
Private Sub Workbook_Open()
Call showmenu
End Sub

Sub showmenu()
With Application
.WindowState = xlMinimized
AppActivate .Caption
End With
mainmenu.Show
End Sub

before the hyperlink is called the form stays on the desktop and can still be accsesed after the hyperlink taget file has been closed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 03:23 AM	#1
jeffh New Member Join Date: May 2002 Posts: 2	Hi, I have a form which is used as a custom 'front end' for an excel sheet which contains data and hyperlinks to local files. When the hyperlinks are activated using the follow command eg Excel.Worksheets("sheet1").Cells(lookup, 1).Hyperlinks.Item(1).Follow this all works fine except when the target file opens in a new application eg adobe reader, excel is minimized to the taskbar, and wont restore to it's normall size when the taskbar icon is cklicked. Does anyone have any ideas on how to restore the excel window. thanks jeff

May 24th, 2002, 04:06 AM	#2
jeffh New Member Join Date: May 2002 Posts: 2	I've worked out a solution...Think it might be a bit of a bodge but it works reliably. thanks to colo for his advice on minimimzing workbooks. If the workbook is minimized: Private Sub Workbook_Open() Call showmenu End Sub Sub showmenu() With Application .WindowState = xlMinimized AppActivate .Caption End With mainmenu.Show End Sub before the hyperlink is called the form stays on the desktop and can still be accsesed after the hyperlink taget file has been closed.