+ Reply to Thread
Results 1 to 2 of 2

Only activate macro on weekdays

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Only activate macro on weekdays

    Hi Folks,

    I've got the following macro that, dependent upon the time of day, runs another macro called "TheSub"
    Please Login or Register  to view this content.
    Is it much of a change to ensure it will only operate on weekdays? (so if Today = Saturday or Sunday) it doesn't activate). Or would that require a significant rewrite?

    Just trying to settle my idle curiosity on this one :-)

    Thanks!

    MM

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,336

    Re: Only activate macro on weekdays

    None of what you posted is actually relevant to the question. At a guess, your code that runs, or schedules, the macro should test the weekday of the RunWhen date.
    Everyone who confuses correlation and causation ends up dead.

+ 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. how to create a macro with only weekdays print in every page ?
    By willy292 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2017, 10:42 AM
  2. [SOLVED] Activate word document from excel, run macro, copy results then activate excel
    By k1989l in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2016, 08:27 AM
  3. Weekdays - Macro
    By Suzanne1307 in forum Excel General
    Replies: 1
    Last Post: 12-07-2015, 08:18 AM
  4. [SOLVED] Create macro to sort and count number of weekdays in year
    By Davelm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2015, 03:31 PM
  5. [SOLVED] Macro/Formula to skip or omit values from weekends to just weekdays.
    By escapes88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2013, 08:00 AM
  6. Replies: 0
    Last Post: 01-27-2005, 04:06 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