Open Form when file opened

  • Thread starter Thread starter Dana
  • Start date Start date
D

Dana

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.
 
Back
Top