Excel sheet with form - Path/File access error
 

Hi. I use Excel 2003. I created a control toolbox form accessing data in the
workbook. Added code to load & show the form when workbook is opened. The
first time it is opened, no problem. The second time it is opened (without
reopening Excel) I get first a "Path/File access error", and the debugger
highlights the line "Load UserForm1". The odd thing is there are no projects
in the Project Window and if you click in the Properties drop down it shows
"Workbook" multiple times. Since it can't see the project it can't load the
form. When I stop the debugger it wants to send error report. I've tried
creating from scratch but receive the same error. Seems like corruption but
not sure how to proceed. Thanks for any help!

Excel sheet with form - Path/File access error
 

Hi

As always show us your code, so we know where to start.

Regards,
Per

"Jon" wrote:

Hi. I use Excel 2003. I created a control toolbox form accessing data in the
workbook. Added code to load & show the form when workbook is opened. The
first time it is opened, no problem. The second time it is opened (without
reopening Excel) I get first a "Path/File access error", and the debugger
highlights the line "Load UserForm1". The odd thing is there are no projects
in the Project Window and if you click in the Properties drop down it shows
"Workbook" multiple times. Since it can't see the project it can't load the
form. When I stop the debugger it wants to send error report. I've tried
creating from scratch but receive the same error. Seems like corruption but
not sure how to proceed. Thanks for any help!