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