The PC HelpSite
www.officehelp.biz
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
Traditional Calendars for Excel

Application Microsoft Excel Version 4.00
Author OfficeHelp
Tested on versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97

Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.

Contact Us for Support Main Page FREE DEMO

FAQ - Frequently Asked Questions

Why do I get a Macro security warning when opening the Traditional Calendars for Excel? 

There are no security risks associated with this Macro! However, a generic warning message will be displayed on most systems, or Macros may be disabled. For a general overview of Macro security issues, read this article.

Macros are a very useful tool to automate tasks in Microsoft Office. Unfortunately, like another programming language, it can be misused. There are Macro Virus, so Microsoft Office can be configured to request permission to run macros. Only run macros from known sources. OfficeHelp.Biz macros are Virus Free and can be open with confidence. Microsoft Office XP/2003 Warning: Macros may need to be activated. Follow instructions on the message Microsoft Excel XP/2003 will show, if necessary. Read this article for additional information.

Help - The button doesn't work but there are no warnings 

If you can open the Microsoft Excel file (both the DEMO and/or the commercial version) and get no warnings but the button just won't work, you have Macro support disabled. Please refer (click here) to our article on Macro security issues for information on how to configure Microsoft Office Macro security settings.

How do I get Support ? 

Use the Support Contact Us page on this website. No registration is necessary. Clearly describe your problem and contact details. We will get in touch with you ASAP. Also, the generic Contact Us page is present at the top of EVERY page on this website . Click here to jump to it


User Support

Can I stop the macro while it's running?

Yes. Press the ESC key and it will stop with a warning message that it was interrupted before finishing generating the calendar.

What is the Legend? How does it work?

The legend will add at the bottom of the resulting calendar a "Legend" of your Holidays & Special Dates events:

  • Days: Lists each individual event on the list
  • Categories: Only lists individual categories. Each category will have a single entry regardless of the number of events on it.
  • None: No Legend will be added to the Calendar.

How to input Holidays & Special Dates for the Calendar?

Insert data for the Holidays & Special Dates on the appropriate Input table:

  • Color: Color to use for the dates background. Just change the cell background color using the taskbar button for that
  • Category: Insert the type of event (Holidays, Meetings, …) for the Category Legend. Use the same color for each category.
  • Start Date: Date when the event should start.
  • End Date: Date when the event should end.
  • Day: Insert the specific name of event (holiday name, specific meeting, …) for the Days Legend

How to personalize text and colors?

Some text labels and font or background colors can be personalized:

  • Month Names: Insert the desired month names on each month cell, over the supplied ones (full name in English)

  • BG Colors: Change the background of each cell, the color will be used for the appropriate calendar cells. Leave reference text as is.

  • Font Colors: Change font color as desired. The color will be used for the appropriate Calendar font color. Leave reference text as is.

  • Weekdays: Insert the desired weekday names on each weekday cell, over the supplied ones (short name in English)

What is a Background Picture? How does it work?

You may insert a background picture on your calendar by selection "Use Background Picture" for this input cell (C7). By default it is disabled. If you activate this option, you will be prompted to select a picture file on your hard drive. The picture will be used as a Calendar background both on the screen and on paper (if printed). REMEMBER to change font and background colors appropriately or some text may be hard to read against a colored background. Font and background colors for several items are user configurable.

How does the Traditional Calendars for Excel knows when the Holidays & Special Dates end?

The macro will stop on the first line with no data on it. So if you leave a intermediate empty line, it will stop there even if more events exist after that line.

Can I change the resulting calendar?

Of course. It's an Excel Sheet like any other. There is nothing special once it's generated, only colored cells and data.

Can I save the resulting Calendar with the events? Can I have several copies?

Again, of course. It's a regular Excel file. There are NO MACROS on the resulting plan, only on the generator file.



Contact Us for Support Main Page FREE DEMO

www.OfficeHelp.Biz

(c) 2004 - 2024 OfficeHelp.Biz