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

"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

In the VB editor (Alt+F11) choose the workbook in the left menu. Here you
can put your code in this sub:

Private Sub Workbook_Open()

End Sub

Note that this only works when macro's are enabled when you open the file.

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