Time Stamp + Lock Functionality Macro

Hi All,

This is my first post so please bear with me...

Currently in work we have checklists that are time stamped, where the date, time and User ID is generated when clicked & we have a paperless template which has a lock functionality macro. The lock functionality macro button when clicked means no amendments can be done to the template from this point onwards. What I am trying to do is combine them both, a double lock functionality, so to speak.

What I want is:
- A macro where when the button is clicked first time a time stamp is generated somewhere on the page (with date, time and User ID) and then when 2nd clicked, the whole template is locked & preferable the time stamp from the 2nd click is also generated with this same information.

Does anyone have any idea how to do this? We currently have Office 2010 in work.

Thanks
Rick

Thanks for the feedback.

I want to trigger the macro by click on a button, not double clicking anywhere if possible. Currently we double click to generate the time stamp but I'm hoping got get this via a button. For the current time stamp macro, these cells are protected already so can only be altered with the password.

I will get the coding we currently have tomorrow and post on this thread. I already have the macro time stamp coding, but I wouldn't know how to write the macro coding for: Initial time stamp generated in a certain cell; lock the template; and finally generate another time stamp in a different cell.

I'm not sure what you mean by the addresses of these though...

That is brilliant!

Thank you. I'll try this tomorrow and potentially might have a few more questions from then!

Great idea.

I'll give it a go tomorrow in work. I do like the idea of the caption changing so the User knows what the click is entailing. I might struggle to be honest though with that! I'll attach the coding/spreadsheet to here tomorrow if I am having issues if you dont mind taking a look for me? Thanks again.