This may be your Personal.xls file which contains your local modules. Check
to see if Window/Unhide is grayed out. If it is then it is your personal.xls
file. In this case, with the personal.xls file as the activewindow, just on
Windows / Hide, hide personal.xls. Now personal.xls will open hidden. Be sure
and choose save changes to your personal.xls workbook.

Regards,

Alan


"Gerry Cornell" wrote:

Excel 2000. I created an update Macro and now whenever I open any
Excel file a personal.xls file opens as well as the file selected.
Clearly I am not using a right option when saving.

Many of my excel files are using reused, many every month. I copy last
months file to next months folder, rename the file and run the update
macro and then amend other data as necessary.

How should the particular update macro be stored? What strategy should
I employ for saving each update macro as they vary from one macro to
the next?

TIA


--

~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~