"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.