It's been awhile, but I have seen posts like this:

I have seen posts like this that:

Private Sub Workbook_Open()
Application.OnTime Now, "Continue_Open"
End Sub

Then in a general module:

sub Continue_Open()
'your real code here
end sub

Sometimes there would be timing issues that could be avoided this way. (I've
never seen this in real life, though--but others have.)

wrote:

Dave,

Many, many thanks - that worked a treat..!! I'm awestruck because its
hard to tell how many years of experience went behind that simple,
left-field solution :-)

I've tested your solution on a couple of PCs so far - all worked fine.

Heck of a relief because I'd made a commitment that this opening the
URL workbook was easy stuff anyone could do, but then it blew up over
this illogical problem and I've been sweating all weekend trying to
figure a solution. You've saved my derriere!

Much appreciated again,
Chris Adams

Dave Peterson wrote:

Try moving the code from workbook_Open() to Auto_Open() (in a general module).


--

Dave Peterson