excel data forms

**phillb** · 06-14-2007, 06:05 AM

Hi,
I am trying to get an excel data form to open automaticaly for a spreadsheet every time I open the workbook. Does anyone know how this can be done???

**dominicb** · 06-14-2007, 08:36 AM

Good afternoon phillb

Try :

Sub Auto_Open()
ActiveSheet.ShowDataForm
End Sub

HTH

DominicB

**phillb** · 06-15-2007, 04:42 AM

Thanks Dominic. Unfortunately I am actualy using a standard form automaticaly generated by excel and am unsure how to alter the code for this. Is there any other solution that you may know to this??? Any help would be much appreciated.

**dominicb** · 06-15-2007, 08:43 AM

Hi phillb

I am actualy using a standard form automaticaly generated by excel

Not sure what you mean by this. If you are referring to the standard dataform (Data > Form), then this is the dialog box opened automatically by the macro I supplpied.

Can you expand?

HTH

DominicB

**phillb** · 06-18-2007, 04:17 AM

I think that this may be the solution I am looking for. How do I enetr this new code???

**dominicb** · 06-18-2007, 08:03 AM

Hi

Open just the spreadsheet you want to affect in Excel.
Press Alt + F11
Go to Insert > Module
Copy the code from above into the large blank pane that appeared
Go to File > Close and Return to Microsoft Excel

This should then save with your workbook and run automatically every time it's opened.

HTH

DominicB

excel data forms

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

excel data forms

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions