Re: problem with webbrowser in excel

On Tue, 12 Apr 2005 at 00:10:45, Mike NG (Mike NG <sweepdog@xxxxxxxxxxxx>) wrote: 
I am doing the following

Creating a new spread***

say On Sheet2 creating some simple code such as

'option explicit
Private Sub Worksheet_Activate()

With WebBrowser1
   .Navigate2 "www.google.co.uk"

   Do Until .ReadyState = READYSTATE_COMPLETE
       DoEvents
   Loop

   MsgBox "OK"
End With

End Sub


Office2000 with WIndowsME and IE 6.0

I've read about conflicts between gator (which I don't run - but I do
run roboform which is a similar product) - just wondered if anyone has
had this recently and knows the fix.  My code is relatively simple, so
it's not that I am doing anything bad is it?

>
Woops

If I flick from sheet1 to sheet2 google appears OK, by if I flick back to sheet1 again I get an error in MSHTML.DLL
--
Mike
.