Private Sub Workbook_Open()
MyForm.Show
End Sub

Placed in Thisworkbook module.


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 12:45:01 -0700, Nadine
wrote:

Have an excel workbook stored on a shared network drive
created a form for data entry.
Is there a way to get the form to immediately come up when a users opens the
workbook