Opening Forms error with Workbook_open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having upgraded my pc to Office 2003 I now get an error message in a
spreadsheet that opens a form from the workbook_open event.
The first error message is: Path/File Access error.
Then another message: Could not find specified object.
The Spreadsheet will then crash.

It's like it tries to run the Open event code before loading up the forms.
Is there some code I should run to ensure the forms are loaded before the
Open code runs.
Has something changed with forms since excel 2000?

( the Load Userform1 line gives the same error as Userform1.show)
 
Hi Merlins,
Having upgraded my pc to Office 2003 I now get an error message in a
spreadsheet that opens a form from the workbook_open event.
The first error message is: Path/File Access error.
Then another message: Could not find specified object.
The Spreadsheet will then crash.
Click to expand...

Try moving the code that opens the form to a sub in a normal module and
use the OnTime event in the Workbook_Open event to fire that (new) sub.

I would also recommend cleaning your project using Rob Bovey's code
cleaner: www.appspro.com

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '424': Object Required 2
Preventing workbook_open code executing. 2
Userform problem with "Run Time Error 75" 15
Run Time Error 75 1
Getting error with load/unload of UserForms?? 2
hyperlinking to excel program with userform 1
Excel sheet with form - Path/File access error 1
VB Error 5 loading userform using Workbook_Open 1

Back
Top