Look at this for an example of a time and date stamp:
http://www.mcgimpsey.com/excel/timestamp.html

You can protect your cells, with a password:
http://www.uwgb.edu/compserv/ehelp/excel/protect.htm

Now to modify the cells, you will have to unprotect the range, do the
modification, and then re-protect the range. This id doable in code; not to
difficult wither. Let's take one step at a time though. Get the first part
working to your satisfaction, and then post again if you have more questions
about how to unprotect a range and then re-protect a range with VAB. Maybe
you can figure it out on your own without even re-posting. :)

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Adam at Star Packaging" wrote:

I am new to the macro world and need some help.

I am trying to set a macro that will place a comment. The information in the
comment should be:

User name. Datestamp (fixed to when macro was applied).

The comment should not be modifiable.

Is this possible?


(The object is to have this macro act as a "signature" for certain users
showing that they have "signed off" on information in specific cells.
Non-legal, intra-office use only.)

If there is an easier way than the macro suggestion above, I am open to
suggestions.

Thank you very much.