Excel Calendar PRO

Excel Calendar PRO includes two linked images that display the previous and next month in the form of mini calendars. (These can be seen in the screenshot).

In order to add a bit of style to the calendar, you can modify the color palette using a very simple set of color controls. The HUE changes the main color scheme based upon the spectrum above the slider. The saturation varies from gray (0) to full color (100).

Dynamic color scheme controls.

This calendar uses Conditional Formatting to vary the background colors based upon whether the day of the week is Saturday or Sunday.

Excel Calendar PRO includes a macro button that lets you automatically copy the calendar into a new Excel workbook. The values and formats are copied, including the column widths and the color scheme. The mini calendars are also copied into the new workbook. This creates a macro-free calendar in Excel that you can customize to your heart's content.

View the Screenshot to see the buttons and controls.

Using the "Create 12-Month Calendar" button, you can easily create a customizable calendar in a new workbook, where each month is on a separate worksheet. An option in the Settings worksheet allows you to modify how many months are created, so you can create a 6-month or 24-month calendar. This is great for creating academic calendars which usually start in July or August and run for 13-14 months.

Creating calendars using this macro is the preferred way to use Excel Calendar PRO because the calendar is created in a separate macro-free workbook that allows you complete control over formatting and event entry. Using features already built into Excel, you could (1) merge cells to add events that spans multiple days, (2) add hyperlinks that link to special event sites like conferences, (3) add images and clip-art.

The excel calendar has already been set up to print to a normal letter-sized sheet of paper (in landscape). However, you can customize the spreadsheet to print to other sizes and orientations (by changing column widths and font sizes and/or using Excel's page-setup to fit the spreadsheet to other sizes).

Printing a Specific Range of Cells to Any Size Paper in Excel:

1. Go to File -> Print Area -> Set Print Area.
2. Select the range of cells you want to print.
3. Go to File -> Page Setup
4. In the Page tab, select the "Fit To: " option
5. Select print preview and change other printing options as needed.
6. To change the paper size in the Page Setup window, press the "Options..." button and depending upon your printer, the paper size selection may be in the "Advanced..." settings.

Due to the increasing number of requests from our international customers, you can now change the calendar so that Monday is the first day of the week, with a single click! This is done using a checkbox like the one below:

It won't store the entries that you make into a database so that you can keep a history of your appointments or plans. Don't expect this calendar to behave like Outlook or other calendar software. It doesn't remind you when events are coming up.

New Features in Version 1.5.0:

• A fairly major update, with a drastic change to the calendar format
• The .zip file now includes two different versions: Landscape and Portrait
• The color scheme is easier to work with. You can still adjust the brightness by setting values for L1-L5 in the Settings worksheet, but it should be more straight forward how to modify your color scheme.
• We've removed the "Copy to New Worksheet" feature. It was just in the way.
• This version works with Excel 2007
• Conditional formatting changed to highlight Saturday and Sunday

Version 1.5.0:

• Added an option to change the calendar to Monday first.

Version 1.4g, 1.4h:

• When creating calendars using the macro buttons, the row heights and column widths are preserved
• 1.4h - Updated the Daylight Savings Time formula for the 2007 date change

Version 1.4e, 1.4f:

• Up to 3 holidays (or other yearly events) per day are now displayed in the calendar. For each day, the first 3 lines contain formulas for displaying the yearly events.
• 1.4f includes more specific instructions for adding events (such as bi-weekly and monthly events).

Version 1.4d:

• Added a new macro button for creating a 12-month calendar in a new workbook
• Added an option in the Settings worksheet for specifying the number of months for the new "Create 12-month Calendar" button (default is 12)

Version 1.4c:

• The "Copy to New Workbook" and "Copy to New Worksheet" buttons now automatically set up the print area to print on Letter-size paper in Landscape view. The mini calendars are also copied as pictures.
• Increased the number of rows in the calendar

Version 1.4b:

• Button to copy the calendar to a new worksheet within the current workbook
• "Normal" style font is now Arial so that copying the calendar to other workbooks will usually preserve the column widths

Version 1.4:

• Button to automatically copy the calendar to a new workbook
• Common holidays and events
• Add your own annual events such as birthdays and anniversaries
• Previous and next month "mini calendars"