Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening in Form View
Can an Excel form be opened in form view instead of spreadsheet view? I'd
like clients to open Excel and immediately see the form which they will fill out and that data collated into a spreadsheet. XP 2003 Excel software. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening in Form View
The userform needs excel--it's not a standalone program.
But you could show the userform as soon as you open your workbook: Option Explicit sub auto_open() userform1.show end sub Ankeny JJ wrote: Can an Excel form be opened in form view instead of spreadsheet view? I'd like clients to open Excel and immediately see the form which they will fill out and that data collated into a spreadsheet. XP 2003 Excel software. Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 document not opening with a proper view in Excel 2003 | New Users to Excel | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
Passing variables between a form and macro | New Users to Excel | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) | |||
View of Excel form is different on different computers. | Excel Discussion (Misc queries) |