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
~~~~~~~~~~~~~~~~~