Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Forms error with Workbook_open
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Forms error with Workbook_open
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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Component not correctly registered Error opening Forms in Excel | Excel Discussion (Misc queries) | |||
Need to automatically number order forms in excel upon opening? | Excel Discussion (Misc queries) | |||
Bypass Workbook_Open when opening a workbook with VBA | Excel Programming | |||
Workbook_Open() Error | Excel Programming | |||
Workbook_Open() error | Excel Programming |