Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing a monthly calendar (2000)

    Has anyone seen a set of macros / worksheet that displays a calendar by month and allows a limited amount of user added information in each boxed day? Nothing fancy with set appointment times, just boxes for each day of the month.
    I gave my boss one last year which I thought I had found on the Internet, and he likes it so much he'd like another one for 2004. And HIS boss wants an updated calendar for January 2004. Unfortunately, I don't remember where I might have picked it up. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>
    Any suggestions?
    Thanks.
    Mark

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Printing a monthly calendar (2000)

    Was it John Walkenbach's Month Array Calendar almost at the bottom of the web page? If not, Googling for Excel Calendar gets you a bunch to look at.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a monthly calendar (2000)

    John,
    Thanks for your quick response. Walkenbach's calendar doesn't allow data entries, alas. I'm also googling for a calendar. But, I'll tell you, I would just as soon modify the existing calendar to update to 2004, but I don't understand how the 2003 Excel calendar I have works. The date (1, 2, 3, 30) is in the upper left corner of each day's box, and I can enter information into each day. But when I look at the cell contents, I don't see the date!! I don't see any macros associated with the worksheet. Any idea how this could be constructed?

    Mark

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Printing a monthly calendar (2000)

    Post it as an attachment and we'll get out the artillery! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Printing a monthly calendar (2000)

    Here is something I created several years ago for a friend, to show a hockey teams schedule.

    The sheet "Date items" is usually hidden, but it demos, the month selection.

    You enter the schedule in "Enter Schedule Here" (the gray cols are usually hidden) by adding the month, day, Opponent, and "h" (home) or "a" (away). The year is entered at the top.

    The "Calendar" has a spot to select the month. Each week is composed of 3 "rows", the date, a line for "home/away", and the line for opponent (read from schedule). Condi formatting is used to highlight "Home" games" and set up the "grid"

    Don't know if it is of value, he is still using it and updates the data annually. I haven't looked at in about 4 years, so he is not having any problems with it.

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a monthly calendar (2000)

    John and Steve,
    Thanks for sharing your scheduling calendar and thanks for the offer to look at the file I was working with. I figured out what was going on. In each cell that was a date there was a text box in the upper left corner of the day. The text box contained the number of the day. The rest of the cell was used for entering the notes. In this way, information could be added without touching the actual date. Very elegant. The only problem was changing each date to reflect the position on the day of the week for the new year. That looks like a manual process.
    If anyone would like a copy of this file, please let me know and I'll post it.
    Mark

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Printing a monthly calendar (2000)

    The example I gave will automatically adjust the dates in the calendar

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Printing a monthly calendar (2000)

    Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>

    Try going to http://www.microsoft.com find the office page and then look for templates.
    I am not 100% sure but I think you will be able to find a bunch of Calendar Templates.

    Regards,

    TD

  9. #9
    Star Lounger
    Join Date
    Feb 2002
    Location
    Fort Collins, Colorado, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a monthly calendar (2000)

    OK, I'll get my two cents in also and submit my Excel calendar. In this version, multiple months are "pushed together vertically" to enable easy counting of weeks elapsed between two dates. Much like one of those big wall calendars that shows all 12 months. You simply enter a beginning date and the current week, plus the next 12 months, are displayed. In a second sheet, the days are strung together horizontally for those that like to draw horizontal bar charts showing sequential activities. It took a lot of work to find the right functions and manipulate them to do this!

  10. #10
    2 Star Lounger
    Join Date
    Oct 2003
    Location
    New York, New York, USA
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a monthly calendar (2000)

    Wow - thanks one and all for the suggestions.
    BTW, the templates at Microsoft are almost all Word templates.

    Mark

Posting Permissions

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