[RESOLVED] Please help a VBA newbe

[ROB IN RWC]

This is what I need.
1. When the workbook is opened for the very first time, I need it to prompt (see existing macro) for the year that the information is being entered.
2. This entry needs to be added to the end of all existing worksheets, i.e. Jan06, Feb06, ...... NOTE: This should only happen the first time it is opened!
3. On closing, it nees to prompt for a "saveas" name so the original does not get overwritten.

Thanks in advance.
-robert My email

p.s. In trying to learn, it seems as though a bunch of crap was attached to the VBA section. How and what do I clean up?