How do I create a form to open when a file/spreadsheet is opened?
Example:

Dept Name Hours Vac Sick Total
adb Joe 24 8 8 40(sum of the
hours entry)

The form would just be the information above to key in.
when the file is opened I want the keyer to see the fields that need to be
keyed in. I don't care if she can see the spreadsheet or not while she is
keying in information.
also the ability to 'Add New Employee'

You could use Data Form...


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dana" wrote:

How do I create a form to open when a file/spreadsheet is opened?
Example:

Dept Name Hours Vac Sick Total
adb Joe 24 8 8 40(sum of the
hours entry)

The form would just be the information above to key in.
when the file is opened I want the keyer to see the fields that need to be
keyed in. I don't care if she can see the spreadsheet or not while she is
keying in information.
also the ability to 'Add New Employee'

My apologies, I didn't give enough information.
I have already created the form.
I would like the form to open, when the file is opened for the end user. It
doesn't matter to me if the excel spreadsheet shows in the background or not.
I just want the first thing the user see is the input form.
I have done this before - several months ago and can not remember how I
accomplished this.

Thanks for your time.


"Wigi" wrote:

You could use Data Form...


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dana" wrote:

How do I create a form to open when a file/spreadsheet is opened?
Example:

Dept Name Hours Vac Sick Total
adb Joe 24 8 8 40(sum of the
hours entry)

The form would just be the information above to key in.
when the file is opened I want the keyer to see the fields that need to be
keyed in. I don't care if she can see the spreadsheet or not while she is
keying in information.
also the ability to 'Add New Employee'