+ Reply to Thread
Results 1 to 2 of 2

End all Application.OnTime procedures

  1. #1
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Question End all Application.OnTime procedures

    Hi there,

    I am using the Application.OnTime procedure within VBA to determine session information about the user's of my program.

    This works great as it gives me accurate details about the time the excel application is the activewindow within microsoft windows.

    One issue with using this is that after the workbook is closed any remaining procedure calls re-open the workbook.

    How do I end all these procedures when the workbook is closed?

    Cheers
    Jordan

  2. #2
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Re: End all Application.OnTime procedures

    Solved by running
    Please Login or Register  to view this content.
    on workbook close.

    Cheers
    Jordan

+ 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. Application.ontime
    By hatrickx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 09:18 PM
  2. [SOLVED] Application.OnTime VBA
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2013, 05:41 PM
  3. [SOLVED] Help with Application.OnTime (was Application.Wait Now)
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-29-2012, 01:18 PM
  4. Application.OnTime
    By albatross32 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-17-2011, 03:15 PM
  5. Ontime procedures
    By ironmouse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2005, 05:05 AM

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