lock cell from further change

jammoca

Banned
Joined
Nov 6, 2002
Messages
1,100
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 ??
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,753
Members
413,930
Latest member
Nela817

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top