Hello FCC,
Since you are opening the workbook, Excel doesn't know the user form is
an object in the workbook. Try this method...
With ThisWorkbook
Load .PrinterSettingsForm
..PrinterSetttingsForm.Show
End With
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=558279