I have had this problem for about five weeks now and either I do not
understand something or a Microsoft problem exists.

When saving a Macro (and for some reason they have been disappeaing) I am
assuming that the following applies.

All Open Workbooks means for every WorkBook in Excel regardless of what
Folder(Directory) the WorkBooks are in. These have been my major problem!

WorkBookName.xls I feel is the one I want. I am under the impression it
saves the Macro in this WorkBook Only! However when I close Excel and
Re-Open it, it shows that the Macros are available to All Open Workbooks. If
I forget to change it to WorkBookName.xls, it destroys all of the Macros in
all WorkBooks.

This WorkBook I think means just temporary changes until you are done with
the current WorkBook.

This dilema has cost me a fair amount of money from Microsoft Excel Support
and they have not been able to assist me at this time. They do have my code
and the same thing happens to them in India as it does here.

Naturally I have saved the code in NotePad and re-applied it when this
occurs, but it is very frustrating when someone else has the problem.

Thanks for any assistance Group!

J. Q.