Saving macro in excel

[horsefish01]

So over the time, I've been helped 100's of times in here with "complete" macros.

I've used several of them over and over again, and everytime I have to go searching thorugh stuff to find the one I need.

Is there some kind of add in or way to "save" macros in excel, so I could always have them all available?

[Alf]

Copy you macro to your "Personal Macro Workbook"

https://support.office.com/en-us/art...0-6e4c3f5ee566

Alf

[jomili]

For macros that you create (or copy from elsewhwer) you can save them in your PERSONAL workbook. PERSONAL opens in the background of Excel (once you create it by recording a single macro in it). Once your macros are saved there, you can add buttons to your QAT to call the various macros. Since PERSONAL is open whenever Excel is open, your macros are always ready to be called no matter what workbook you're working in. See http://www.rondebruin.nl/win/s2/win004.htm. That page also talks about Ron's "MyAddin.xlam", a ready-made solution that you can pour your macros into.