I may be missing the point or be totally off track but can't you build the
time stamp into the macro?
To insert the current date and time, press CTRL+; (semi-colon), then press
SPACE, and then press CTRL+SHIFT+; (semi-colon).

--
Russell Dawson
Excel student


"Chris" wrote:

I have a Time Tracker that I have created in a spreadsheet with a button that
contains a macro that unprotects the worksheet, puts a timestamp in the
selected cell, and then re-protects the worksheet.

This works great up until the point the user tries to type into a locked
cell. The user is prompted with a message box that says the cell is
read-only and if they would like to edit the cell to unprotect the worksheet
(which obviously I do not want). So, I tried getting around this by setting
a password to unprotect the sheet. However, when the macro now runs, it asks
the user to enter a password to unprotect the sheet to be able to put their
timestamp into the cell.

I'm looking for a way to protect the sheet where the user can only put in a
timestamp by clicking the button and does not have the ability to unprotect
the sheet.

Does this make sense? Please offer any suggestions.

Thanks.