How to create a button to stop a clock

[kehong216]

Hi there,

I have the following macro in my Module that shows the real time clock

Please Login or Register  to view this content.

I also have the following macro in the workbook to keep the clock running whenever the workbook is opened.
However, this prevents me from editing the workbook such as unlocking cells
I'd like to create a button to stop the macro of the clock, allowing me to unlock any cells for editing
Any advice would be great! Thanks

Please Login or Register  to view this content.

I also have the following

[zbor]

Please Login or Register  to view this content.

Check does this help.

Inser button you want to click for stopping macro.
let's call it Button1

insert this macro:

Please Login or Register  to view this content.

Then adopt your macro to check is button clicked:

Please Login or Register  to view this content.