Free Picture Calendar Template – Download and make a personalized calendar today!

Posted on January 2nd, 2012 in Learn Excel , VBA Macros - 24 comments

Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!

Printable 12 Month Picture Calendar

Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. See this demo to understand how it works.

Picture Calendar Template Demo

Download Picture Calendar Template

Click here to download the picture calendar template. Enable macros to use it. [6mb]

How to use this?

This is a very simple Excel template. Just follow these instructions.

  1. Once you download the file, you would find 4 sheets inside.
  2. Go to the Monthly Calendar tab and play with the calendar. If you want to change colors, fonts etc. do that.
  3. Now, go to Pics tab. Here we have 12 pics (preloaded with some cute cats & dogs)
  4. Remove all the pics and add your own.
  5. Once you added the pics, resize them so that they can fit in Column B (800 px). Each photo should take up 2 rows (total 600 px maximum)
  6. Once you have added the photos, arrange each photo in 1 cells, starting from B2 (thus 12th pic will be in B24&B25)
  7. That is all, go back to Monthly calendar to check out your own personalized picture calendar.

Bonus: Click on the “Make 12 month PDF” to generate 12 month-wise calendars pdfs.

How does this work?

This calendar uses some of my favorite techniques,

To help you understand how this works, I have made a short video explaining the template, the VBA code & formulas. Go ahead and watch it below:
(Watch it on our Youtube Channel)

Do you like this template?

How do you like this template? Are you planning to use this? Please share your comments, ideas with us. Go ahead and comment.

Written by Chandoo
Tags: , , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

24 Responses to “Free Picture Calendar Template – Download and make a personalized calendar today!”

  1. Gopal says:

    super-liked the photos used... wishing you many more crowns this year and many more to come!

  2. SARAN KUMAR says:

    Lovely Chandoo...

    Keep it up !!!

    Regards,
    Saran
    lostinexcel.blogspot.com

  3. Muruga says:

    hi very nice and good to see the formulas, i think only thing could have been added is displaying of month (ex: January, Feb..) when converted to pdf file which seems to be missing.

    • Chandoo says:

      @Stef@n & all... sadly this template wont look as good or work as well in Excel 2007. You can fix the macro error by assigning the color, however, the picture links cannot be pushed back in Excel 2007 (afaik).

  4. Stef@n says:

    Hey Chandoo,
    all the best for the new year !

    one little question:
    if i change the month "MonthlyCalender" (grey dots)
    VBA shows me a mistake No 438
    and the code stopped in the line
    .ForeColor.Brightness = -0.150000006
    and also in the line
    .ForeColor.Brightness = 0.349999994

    Do you have an idea ?
    Regards
    Stef@n

    i use excel 2007

  5. Dheyaa says:

    Like it !

  6. Carolanne says:

    This template is awesome, the explanation is awesome, this site is awesome and Chandoo is totally awesome. Thanks for your inspiration. Wishing you a wonderful 2012!

  7. Kshitij Balapurkar says:

    Hello Chandu..
    Thanks for the Calender... It is really Good one...and Video is Quite Explanatory...
    However When i Downloaded the file it is giving me an Error!!!! Run time error '438' - Object does not support... Although i have enabled the Macros... Well I could not decode the macro...
    Thanks in Advance...
    And Yes... A Very Happy and Prosperous New Year....
    Chandoo ROCKS!!!!

  8. Saji says:

    Fantastic !!!!
    I can have a customised calender for my kids !!!!

    Thanks a lot
    Saji

  9. venugopal says:

    Hi chandoo, thanks for your continuous support in sending excel specials to me

    wish you a happy new year 2012

  10. mohan says:

    Hi, wish u a happy new year to ur entire
    smiling family. thnx for a calender gift 🙂

  11. Hi Chandoo!
    Impressive and very grateful for sharing your knowledge with us.

    My best wishes to you and your family many blessings!

  12. slyoen says:

    hello great and easy calendar project! howerver pdf macro did not work. did anyone else encounter this problem?

  13. Sridhar says:

    Hi Chandoo,

    First of all wish you and your family a very happy new year. I am sure you will come up with many more innovations and ideas in Excel. Best of Luck.

    This Picture Calendar Template is just brilliant. I have just 1 question here. In the Monthly Calendar sheet, why do the pictures appear in GreyScale even if you Insert colored pictures ??

    Sridhar

    • Chandoo says:

      @Sridhar... I have applied Gray scale effect on the picture link. Just select the picture in calendar, go to format ribbon and from "Color" button, choose the regular color instead of Gray scale.

  14. Ankit says:

    Hi Chandoo,

    I tried opening the file but it would show me an error- "Run time error- 438" "Object doesnot support this property or method". Am I missing something??

    Ankit

  15. Suma says:

    Chandoo, the calander is an amazing idea, I got around with the 438 error by commenting out the code '.ForeColor.Brightness = -0.150000006'. Thank you for the new year gift, wishing you, hui, Vijay and your families a very happy new year!!

  16. Manickkam says:

    The calendar looks really nice. Will use it and let you know how it works out. Have to learn a lot in excel.

  17. Lexi11 says:

    Hello Chandoo,

    I am updating my excel skills and discovered your site. What a gift! Your videos and examples are very user friendly. Thank you for your efforts and sharing of your knowledge.

    Blessings to you and your family.

  18. Binu Thomas says:

    Hi Chandoo, What a fantastic spreadsheet! And amazing technical work to ensure the end user can use it easily. 

    I have a query, can we change the year from 2012 to 2013..  

  19. Pankaj says:

    I think it is restricted to work for year 2012 as when i change to 2013 , there are no changed as dependent on the "Mini Calendar " I have modified it to work for 2013 .BUT i do not know  how to attache the file  in this forum even after login in .

  20. Hemant says:

    HI how to create same calender for 2013 it's realy awesome

  21. […] ?? ????? ??????????? ?????? ?????? ????? ? ????????????? ??? Excel. ??? ???? ????? ?? ??? […]

Leave a Reply