In that case.

Private Sub Workbook_Open()
MyMacro
End Sub


Gord

On Fri, 20 Mar 2009 13:10:02 -0700, Nadine
wrote:

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

"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