Define what you mean by Form.

Do you mean a userform

Do you mean Data=Form from the menus

Do you mean a dialog sheet

do you mean a userform

or do you mean you have designed a worksheet to look like a paper form.

--
Regards,
Tom Ogilvy

"PKyle" wrote in message
...
I have a form in excel with several worksheets that can vary. I have used
a
macro to update the date field when saving the file, so co-workers cannot
"back-date" the date field. However, they have learned to disable macros
when loading the spreadsheet. They also tend to recycle the forms (load a
previously filled out form to modify just a few fields, however, one
coworker typically does not do a thorough job and makes lots of mistakes
which are quite costly to the organization.

If I could convert it to Access, I would, but this form requires a lot of
customization in attachments- which Access cannot accomodate.

I am wondering a few things as I have two problems to overcome:

1: I want to disable use of form if user chooses to disable macros- one
or
two key fields are deactivated or protected if macros are disabled.
2: once the form is saved, I would like to lock a couple of key fields
which essentially inactivates the form from being recycled and used again-
the user has to go back to an empty template- to ensure the form is filled
out correctly.


For a spreadsheet template:
Can I lock certain cells in the initial template form- so that the
first
time the template is opened , the fields can be unlocked by a macro so
the
user can fill them in, but as soon as the file is saved as a worksheet,
these fields cannot be modified again- (ie serial number or case number)
thereby forcing the user to consistently go to the template for a new
instance of the form???

(and in using the template- if they bypass macros- these fields stay
locked- so they cannot defeat the macro features such as actual date/time
stamping and recycling old forms with new information??)

If this is possible- can someone help with the code and means by which I
can
accomplish this? I appreciate this!
Thanks
Paul