Results 1 to 9 of 9

Execute one macro from within another ?

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2008
    Location
    Eureka, Ca
    MS-Off Ver
    Office 2003
    Posts
    21

    Execute one macro from within another ?

    Hi All,
    I've attached a sample sheet here.
    Basically, I've got a caendar that will be created manually for each month.

    The week 1, Week 2, Week 3 etc are all hyperlinks to seperate workbooks where each sheet is for each day of the week (Mon to Fri)

    I've got the macro for clearing each of these weeks already working (no problems there).
    I've also got seperate macros for showing "X"s in the days of Week 1 that are in the previous month (as in this example where Mon to Wed are in June).
    I'll also have macros to do the same thing for Week 5 where days of the week are in the following month.

    Right now I create the calendar by hand, run the macro to clear all of the 5 weekly workbooks & then depending on what day of week 1 is the First of the month I run one of the macros that will "X" Mon to the day before the First.
    I've got macros to do this where each one clears Mon, Mon & Tues, Mon, Tues, & Wed etc.

    My question is:
    At the end of my code to clear the 5 weeks, can I execute the relevent macro to "X" the blank days of Week 1.
    So basically I'd like a simple piece of code to add on to the end that looks at Friday of week 1, if that isn't blank it looks at Thursday, if that isn't blank it looks at Wednesday & so on back to Monday.
    When it finds the first blank it will run the relevent macro to "X" those days of the workbook Week 1.

    My macros to "X" the days of the week are called
    Blank_Monday_Week_1
    Blank_Tues_Week_1
    etc.

    Hope I've given enough info here - Sorry if it's too much.

    Thanks for any help in advance
    John
    Attached Files Attached Files
    Last edited by Originalgoth; 07-06-2010 at 09:15 AM. Reason: Forgot to set notification of replies option

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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