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

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, [email protected] wrote:

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

Thanks works great