When you create a macro, you have the option to store it either in "new
workbook", "this workbook" or "personal macro workbook." I don't have Excel
2000 on the computer I am writing from, but I have it at work and I am
pretty sure the principles are the same in both, judging from your dilemma.
It appears that if you select Personal macro workbook, it ends up in any new
document you create. (Word is similar: you can store a macro in a given
document, or in your global template, which affects all new documents.)

To get rid of them in the 97 version, I'd go to Tools/Macro/Macros,
highlight the macro name and select Delete. You might have to look around
under the "macros in" list, to see all available macros. If this doesn't
work in 97, email me personally and I will check my Excel 2000 at work.

Susan Sutherland


>From: David Grossman <[log in to unmask]>
>I created six macros in one of my Excel 2000 spreadsheets and then
>discovered that they were replicated in all of my other spreadsheets! The
>original macros in the other spreadsheets were deleted and replaced by the
>new macros.
>
>Can anybody guess what caused this to happen, and what can be done to
>remove
>the unwanted macros? I have, of course, given up hope of recovering the
>deleted macros.



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

        The NOSPIN Group provides a monthly newsletter with great
       tips, information and ideas: NOSPIN-L, The NOSPIN Magazine
             Visit our web site to signup: http://nospin.com