AccessMyLibrary provides FREE access to millions of articles from top publications available through your library.
Print your own stylish calendar by using this simple macro.
The WYSIWYG calendar in figure 1 is a handy tool for keeping track of meetings work schedules and deadlines-not to mention holidays and social events. The calendar-generating model, which works in 1-2-3 Releases 2.3, 3.1, and 3.1+, combines a WYSIWYG template with a simple macro to create a calendar for any month in any year from 1900 to 2099. You can add clip art to highlight holidays or other special events, then print the calender by using the built-in print macro.
To create the model, start in a blank worksheet and attach the WYSIWYG add-in if it's not already attached. Hold down the Alt key and press F10, or press the slash key (/) and the letter A, and then select Attach. Choose WYSIWYG.ADN from the list, select NoKey, and select Quit.
Set the global column width to 5: Select /Worksheet Global Column-Width and enter 5. Use the :Worksheet Row SetHeight command to set the height of row 6 to 40, row 9 to 50, an d rows 10 through 52 to 20.
Enter the labels shown in range A1..A5 of figure 2. Use the Range Name Label Right command to assign the labels in range A2..A5 as names for the adjacent cells in column B. To add color to the data-entry cells, highlight cells B2 and B3, select :Format Color Background Yellow, and press Return.
To create the calendar headings and date numbers, you'll have to replace …