Hope some expert can help. Here is what I want to do: I am making a log sheet for machine operators who will enter measurement data. As a sneaky way of gaging how fast they are going I want them to be able to enter the current time and date without them being able to fiddle with it. So what I want is a macro that enters the time and date in a particular cell, but for the operator not to be able enter any data in another way, or forge a false time/date. Also, I have tried creating a macro that enters the time and date(that wont' change when updated) I do this by entering ctrl-shift-; for the time and ctrl-; for the date. The problem is, when I run the macro it gives me only the time it was when I made the macro(???). Can't I make a macro that gives the current time and date. Why is this happening?

Perhaps this might be what you need, or will at least give you a few tips. See "Excel VBA Tips and Tricks" about halfway down the page.