View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Hyperlink excel window problem

I have some code which simply links froma command button on a useform to an
external htm file, which is saved locally, not on the internet.

ActiveWorkbook.FollowHyperlink "Tender files\Photos\index.htm"

When i click the button, the htm file launches, but i cannot get back to the
excel file. the program is there at the bottom of the screen, but alt+tab
does not show it, and even closing all other applications down does not show
it. I assume this is because the userform i clicked from is still active. is
there a way of stopping excel doing this without shutting the userform on
command button click?

Appreciate your help
--
Richard