I don't think I've ever experienced the problem, but the posts that I've read
that suggested this fix guess that it's a timing issue with excel.

xl has lots to do when you open the application and workbook. Sometimes, it
gets confused.

If the problem recurs, I've seen suggestions that go even further.

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



cassidyr1 wrote:

That's great thanks!

I wonder why auto_open works and workbook_open doesn't work?

Thanks again!

Richard

--
cassidyr1
------------------------------------------------------------------------
cassidyr1's Profile: http://www.excelforum.com/member.php...fo&userid=7349
View this thread: http://www.excelforum.com/showthread...hreadid=272507

--

Dave Peterson