+ Reply to Thread
Results 1 to 2 of 2

How to create a button to stop a clock

  1. #1
    Registered User
    Join Date
    11-11-2020
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    49

    How to create a button to stop a clock

    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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,103

    Re: How to create a button to stop a clock

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. day clock start , stop conditional formula needed
    By Hotbeef in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2021, 03:05 AM
  2. Create running stopwatch/timer with 1 button (start/stop). No reset button.
    By leeroy2612 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2021, 12:59 AM
  3. [SOLVED] Running clock or stop watch i a cell
    By dzoomz65 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2016, 04:46 AM
  4. Stop watch/clock using excel
    By OLADOJA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2015, 01:28 AM
  5. can excel be a time clock or stop watch?
    By Anthony Reynard Chinnis in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-15-2006, 01:45 PM
  6. Start Clock/Stop Clock
    By abfabrob in forum Excel General
    Replies: 9
    Last Post: 06-28-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1