Show Userform when Application Opens

[ironhydroxide]

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

 

[Wouter]

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.

 

[Gord Dibben]

Place code into Thisworkbook module.

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


Gord Dibben MS Excel MVP