Is it possible to start an excel workbook with a prebuilt form as the opening
page? The idea is for a data entry person to pop information into form
spaces, and thus populate an excel spreadsheet. My goal is to allow easy
entry for the data punch person, and view the resulting data in
pivottable/chart form. The Data Punch should double click on the shortcut and
be taken right to the form.

Are you talking about a UserForm created with VBA or a sheet set up to act as
a form?

"Jaytee" wrote:

Is it possible to start an excel workbook with a prebuilt form as the opening
page? The idea is for a data entry person to pop information into form
spaces, and thus populate an excel spreadsheet. My goal is to allow easy
entry for the data punch person, and view the resulting data in
pivottable/chart form. The Data Punch should double click on the shortcut and
be taken right to the form.

Actually I suppose I meant a userform. The idea would be that it would act
like a form in Access, and be there from the start.

"bigwheel" wrote:

Are you talking about a UserForm created with VBA or a sheet set up to act as
a form?

"Jaytee" wrote:

Is it possible to start an excel workbook with a prebuilt form as the opening
page? The idea is for a data entry person to pop information into form
spaces, and thus populate an excel spreadsheet. My goal is to allow easy
entry for the data punch person, and view the resulting data in
pivottable/chart form. The Data Punch should double click on the shortcut and
be taken right to the form.