hi,

try including the following line before the .show line

load printerSettingsForm

hth

tim

"FCC" wrote in message
...

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