Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation Changing a the contents of a document after a certain date with a MACRO

    Hi, what i have is a timetable report that needs to change for a short period of time between the 21/7 (each year) and the 21/8 (each year).

    I believe that there is some way of programming an AutoOpen macro so that there is a date at which the document will change, then there is a date, after the period of one month, that the document will change back to how it was before.

    My document contains form fields which results in the document being partially locked when sent to recipients - i presume that the changes the macro will make will require the document to be unlocked then locked again once the changes are complete - once the changes are complete, the user will then be able to input their information.

    My documents are attached;

    Timetable 2 (big) is the one that will be in-use most of the year, however i need the middle 6 rows of the table to change to match those of Timetable 1 (so that the rows are smaller).

    Please help,

    Thanks, Alex :-D
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    This looks like it's part of what you've already been given help on at:
    http://answers.microsoft.com/en-us/o...c-07c1cd6124d2
    &:
    http://answers.microsoft.com/en-us/o...0-55cf30644fd2
    and a cross-post of:
    http://answers.microsoft.com/en-us/o...3-d105c4c7a3e0

    For cross-posting etiquette, please read: http://www.excelguru.ca/node/7
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Oct 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey sorry about that. Read that website and am better educated now. Thanks! :-D

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •