Load form when workbook opens
 

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

Thanks

Load form when workbook opens
 

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

On 18 Jul 2006 17:17:23 -0700, wrote:

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

Thanks

Load form when workbook opens
 

Thanks works great