Hi Melanie,

Welcome to the forum

OK, based upon the zipped file that you attached we have:

1. No code in either 'Sheet1' or 'ThisWorkbook'.
2. Module1 is empty.
3. Modules 2, 3 and 4 each contain a single routine related to printing.

Now in order for a routine to run automatically when the workbook is opened we need either :
a) A Workbook_Open event routine (newer code), or
b) An Auto_Open routine (older code).

The attached workbook contains neither of these nor any menu creation routines (or not in the VBE anyway). I'm afraid I'm not familiar with the technique used in this workbook. Are you looking to get the existing method working in 2003 or just for a method of creating a menu to access the routines that will load when the workbook is opened?

A simple menu creation routine is outlined here:
http://vbaexpress.com/forum/showthread.php?t=50

Let us know how you want to proceed.