Excel 2007 - Data Form
 

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

Excel 2007 - Data Form
 

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

Excel 2003 - Data Form
 

Sorry, meant to say Excel 2003

"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

Excel 2007 - Data Form
 

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

Excel 2007 - Data Form
 

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