OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Calendar Plan - Year Planner Template

Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
Macro Microsoft Excel OfficeHelp 19.95 USD
9.95 USD

50% DISCOUNT on this Macro for limited time.

Traditional Calendars for Excel - Version 4.00

Tested on Microsoft Excel 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

(How to Buy)

 
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®.


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.




50% DISCOUNT on this Macro for limited time.

Traditional Calendars for Excel - Version 4.00

Tested on Microsoft Excel 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

(How to Buy)

Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
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®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2018 OfficeHelp.Biz