A complete guess.

Try cleaning up your windows temp folder.

close excel
Windows start button|run
%temp%
and delete everything you can.

Sometimes, the mass of temp files confuses excel.

If that doesn't work, I'd try moving the code from workbook_open to Auto_Open
(in a general module).

If that didn't work, I'd try:

option explicit
sub Workbook_open()
application.ontime now + timeserial(0,0,1), "Continue_Open"
end sub

And create a
Sub Continue_Open()
'with your code
'in a general module
end sub





Spencer Hutton wrote:

I have a userform.show statement running with the workbook_open event.
if i close my workbook and do not save, the next time i open it, i get the
error, path/file access error and then the vb error, could not find specified
object. does anyone know what causes this. every app i have written with a
userform.show statement on this event has never caused me a problem like
this...

--

Dave Peterson