+ Reply to Thread
Results 1 to 2 of 2

basic clock that always runs

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Atlanta, GA
    MS-Off Ver
    2010
    Posts
    1

    basic clock that always runs

    Hello all. First time here, not 100% how this works. Only worked with a few basic vba functions and trying to get a basic clock that does nothing other than automatically run and keep time while the workbook is open. I've had a few of them working when manually starting them though really could use one that can be forgotten about and it just runs.
    Thank you much,
    Marc

  2. #2
    Registered User
    Join Date
    01-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: basic clock that always runs

    Hey Marc,

    I don't have any specific code to provide you, but if you have one that works when manually started, you could call it from the Workbook Open Event.

    This would be done by placing code in the private module of "ThisWorkBook"

    you would enter:

    Please Login or Register  to view this content.
    This would run the clock macro whenever the work book is open.

    - Melk

+ 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. Clock In/ Clock out macro
    By DevonH in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2019, 01:33 PM
  2. [SOLVED] Macro that runs every minute when System Clock changes minute?
    By naira in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2013, 04:11 PM
  3. Default time from 12 hour clock to 24 hour clock
    By MR-77 in forum Excel General
    Replies: 3
    Last Post: 03-31-2011, 04:15 PM
  4. Clock in/Clock out calculation
    By phatpandas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2007, 03:23 PM
  5. [SOLVED] 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