+ Reply to Thread
Results 1 to 4 of 4

Using Application.Ontime issue

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Yorkshire
    MS-Off Ver
    2016 32bit
    Posts
    43

    Using Application.Ontime issue

    Hi all,

    First time using Application.OnTime to continuously auto-update a cell for me.

    Please Login or Register  to view this content.
    Every time I run it I get the 'Cannot run the macro "C:\[...]'!Recalc'. The macro may not be available in this workbook or all macros may be disabled.'

    Macro security is off, plus things from the vba is trusted. No other workbook is open. The workbook is saved as a macro-enabled book. Other simple macros work.
    Am I doing something simple wrong?

    Regards,
    Luke
    Last edited by TinyDamooge; 01-10-2017 at 07:49 AM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Using Application.Ontime issue

    The procedure 'StartTime' must be in a standard code module. Is it?

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    Yorkshire
    MS-Off Ver
    2016 32bit
    Posts
    43

    Re: Using Application.Ontime issue

    No it wasn't - I wasn't aware it had to be.

    Putting it into a module fixed it straight away, thank you.

  4. #4
    Registered User
    Join Date
    09-03-2015
    Location
    Yorkshire
    MS-Off Ver
    2016 32bit
    Posts
    43

    Re: Using Application.Ontime issue

    No it wasn't - I wasn't aware it had to be.

    Putting it into a module fixed it straight away, thank you.

+ 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 and ScreenUpdating compatibility issue
    By the_gunslinger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2016, 07:01 PM
  2. Application.Ontime
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-08-2016, 03:40 PM
  3. VBA - Application.Ontime Cancel Fails to Method 'ONTIME' of Object 'Application'
    By LordAzuRa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 03:21 PM
  4. Application.Ontime issue running macros in wrong spreadsheet with multiple sheets open
    By aaron.irvine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 09:42 PM
  5. Application.ontime
    By hatrickx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 09:18 PM
  6. [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
  7. [SOLVED] Help with Application.OnTime
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2006, 01:10 PM

Tags for this Thread

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