Whenever you use the macro recorder to record a macro, Excel assigns it a name of MacroN. The N is the next available macro number. So the first macro recorded would be Macro1, the second would be Macro2, etc. Excel will allow you to pick a different name when you record the macro, most folks do not avail themselves of this feature for quick-and-dirty macros.
Because of this naming practice, it is very easy to gum up your workbooks with macros you no longer need. You most likely cannot even recall what they do!
The solution is to periodically clean out your macro list. You should always delete anything that is in this default naming sequence. Doing this periodically means that your files will take up less space and your Excel workbooks will load much more quickly.
To delete a macro, just display the Macro dialog box (press Alt+F8), select the macro you want to delete, and then click Delete.
That’s all there is to it and it’s a good practice!