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.
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
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
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.
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
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
Insert data for the Holidays & Special Dates on the appropriate
- Color: Color to use for the dates background. Just
change the cell background color using the taskbar button for
- Category: Insert the type of event (Holidays,
Meetings, …) for the Category Legend. Use the same color for
- 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
Month Names: Insert the desired month
names on each month cell, over the supplied ones (full name in
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
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
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.