lock cell from further change

[jammoca]

I'd like a button to run a macro that returns the current time ( in mm:ss:000 ) using =Now() in cell A1 and another macro to return the current time ( also in mm:ss:000 ) using =Now() in cell A2.

I'll be pressing the second button shortly after the first button and will be wanting the difference in times to appear in cell A3

I need a code to stop A1 changing from its first result when the second button is pressed.

I know there are stopwatch functions out there but I've struggled getting them to work for what I want, so I'll try this path for now.

Any clues ??

 

[StephenR]

Untested but try copying A1 and pasting as a value over itself.