How to make a calendar using excel

Written by faith lawless
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make a calendar using excel
Use Excel to generate a calendar.

Microsoft Excel's use of Visual Basic macros makes it possible to generate a calendar from the spreadsheet software. Running this macro requires you use the VB code designed for easy calendar creation, which Microsoft provides as an example. Once you've copied the VC code to your workbook, Excel automatically generates a calendar to print or keep online. To use the macro, you need access to the Developer Ribbon. If it isn't available, enable the Developer Ribbon under Excel Options. If running VB code is too complex, use a Template available from Microsoft for an easy method.

Skill level:


  1. 1

    Open Microsoft Excel and select "File," and then "New" to open a new workbook.

  2. 2

    Click "Visual Basic" on the Developer Ribbon.

  3. 3

    From the Insert menu, click "Module."

  4. 4

    Copy the Visual Basic for Applications code to create the calendar to the module sheet of the workbook (full link to code example in Resources).

  5. 5

    Select "File," and then "Close and Return to Microsoft Excel."

  6. 6

    Select the tab for Sheet1, and from the Developer ribbon, select "Macros."

  7. 7

    Select "CalendarMaker," and then select "Run" to make the calendar in Excel.

  1. 1

    Open Microsoft Excel and open a new workbook by selecting "File," and then "New."

  2. 2

    Review the templates, which are grouped by category, select the one that best reflects the calendar you need. Click "Create" to use the calendar template in Excel.

  3. 3

    Review the alternatives on the Microsoft site if you don't see a template that is appropriate for your calendar needs (full link in Resources). Click the template that represents the best calendar option, and then click "Download." Accept the terms and conditions, then use the template when it opens in a new workbook.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.