Open Form when file opened
 

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'

Open Form when file opened
 

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'

Open Form when file opened
 

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'