Place code into Thisworkbook module.

Private Sub Workbook_Open()
frmCalendar.Show 'Edit form name to suit.
End Sub


Gord Dibben MS Excel MVP



On Tue, 18 Aug 2009 14:45:02 -0700, ironhydroxide
wrote:

I am wondering how one gets a userform to appear as the first thing when you
open an XLSX file. (2007)

I know it was somewhere here, but i cannot seem to find it now.

Thanks for any replies

ironhydroxide