| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What replaces the Data/form menu item in Excel 2007? | New Users to Excel | |||
| How do get to data form tools in excel 2007? | Excel Discussion (Misc queries) | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| Where is the Data Form option in Excel 2007 | Excel Discussion (Misc queries) | |||
| Data Entry Form (similar to default Excel DataForm) | Excel Programming | |||
Hybrid Mode
