Load form when workbook opens

M

melton9

Its been a while since I've worked in excel. How do I automatically
load a form when the workbook opens?

Thanks
 
G

Gord Dibben

Right-click on the Excel logo at left end of menu bar.

Select "View Code".

Copy/paste this into that module.

Private Sub Workbook_Open()
Userform.Show
End Sub


Gord Dibben MS Excel MVP
 
Top