+ Reply to Thread
Results 1 to 7 of 7

Stop timer

Hybrid View

  1. #1
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Stop timer

    Good job Philb1.

    The difference is the 'On Error resume Next' which is needed to suppress the Runtime error that occurs when the timer is not scheduled (either not scheduled or when RotateRows() is executing).

    It is also good programming practice to put StopTImer() in the Workbook_BeforeClose() routine in the ThisWorkbook code module. If this is not done, the spreadsheet may unexpectedly 'rise from the dead'.

    Lewis
    Last edited by LJMetzger; 02-23-2016 at 03:28 PM.

+ 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. Timer Stop when other CommandButton Clicked
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2015, 09:23 AM
  2. Start/Stop timer
    By JonathanB2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2014, 07:00 AM
  3. how to stop a macro timer running more then once
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2013, 08:58 PM
  4. [SOLVED] Timer non-stop to run?
    By alee001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2013, 03:46 PM
  5. stop watch and timer in excel
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 05:50 AM
  6. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  7. stop this countdown timer macro
    By jacksten in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2012, 10:57 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