Hello to all can anyone help

[henry1951]

First of all like to say Hello to everyone i am a new here so please be patient with me LOL and at 67 takes a little longer for things to sink in

i have just done a sign in sheet for work staff and i have a command button that puts in the date and time of start of shift and the same for ending the shift the problem i have is how can i stop anyone changing the time in the cells

The command button can only be pressed once then it is disabled until i reset all by another command button

i have tried lots of ways but none seem to let me enter the date and times once the cells are protected

dont know if that make any sense

But thanks in advance if anyone can help

 

[mumps]

The macro would have to unprotect the sheet at the beginning and then re-protect it at the end. Something like this:

Sub Test()
    ActiveSheet.Unprotect
    'your code here
    ActiveSheet.Protect
End Sub

Without seeing the macros you are using, it is difficult to give you more specific help.