Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() and Object Not Found
Hi, I am using the Workbook_Open() to open a form that I've built in VBA. The Sub is very simple: Code: -------------------- Private Sub Workbook_Open() printerSettingsForm.Show End Sub -------------------- The only problem is when running this I get the Run-time error '424' Object required And it centers on the sub. I am assuming the problem has to do with the fact I haven't properly declared or instaniated the object/Form printerSettingsForm. I tried goggling, but I couldn't find the proper technique to declare an object. So I was wondering how I could fix this problem? -- FCC ------------------------------------------------------------------------ FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888 View this thread: http://www.excelforum.com/showthread...hreadid=558279 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel found unreadable content in 'stock.chart.object.xlsm' | Charts and Charting in Excel | |||
Replace object causes an error if search text not found | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Workbook_Open | Excel Programming | |||
WScript object not found (???) | Excel Programming |