Word 7 Calendar Wizard Creates One Month Only (141876)

WORKAROUND

WARNING: ANY USE BY YOU OF THE CODE PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this macro code "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

The Calendar Wizard has a variable called MaxValidYear which is not shared, causing the Calendar Wizard to complete incorrectly when the Starting Year and Ending Years are different. The MaxValidYear variable needs to be a shared variable.

To change the MaxValidYear to a shared variable, perform the following steps:

1. Click New on the File menu.
2. Select the Calendar Wizard from the "Other Documents" tab. (Do not double-click the Calendar Wizard icon.)
3. Press and hold the SHIFT key, then click OK. Keep the Shift key pressed down until a new blank document appears on the screen.
4. Select Macro from the Tools menu.
5. Select the StartWizard macro and click Edit.
6. Find the "Dim MaxValidYear" statement. It should be the 10th DIM statement at the top of the wizard.
7. Change the "Dim MaxValidYear" statement to read "Dim Shared MaxValidYear".
8. Click Save on the File menu.
9. Click Close on the File menu. If prompted to save the StartWizard macro, choose Yes.