Excel 2007 - Data Form

[Nadine]

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

 

[Nadine]

K, I created a macro to open the form, how can I get the macro to
automatically run when open the workbook.
Thanks

 

[Nadine]

Sorry, meant to say Excel 2003

 

[Gord Dibben]

Private Sub Workbook_Open()
MyForm.Show
End Sub

Placed in Thisworkbook module.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

In that case.

Private Sub Workbook_Open()
MyMacro
End Sub


Gord