Missy-
It is true that Personal is a great place for you to store all your macros.
However, if you intend on others to use your macros as well, then one
workbook to store them in works great.

Let me explain before someone pops a top and starts to say why I am wrong.
If you would like others to use the macros that you send time making, I am
sure that you made them to help you increase your productivity to some
degree. This should hold true for others are well then, that they could
benefit from what you have made. Or if the case is that you have a common
task that has to be worked often, a macros workbook is a great idea. If the
workbook contains the macros and you set them up to work on other
spreadsheets, a macro workbook works wonders. It allows you to have one place
to make changes or updates to your macros as well as one common place to find
them. Having a toolbar attached to that workbook is very helpful as it will
load when someone opens the workbook for the first time. Lastly, if you ever
send your files to someone, your macros will not be included and thus a
smaller file size for sending. If this interests you and anyone, please
contact me if you would like more info.

David

"MissyLovesExcel" wrote:

Would it be wise to store all macros in one workbook in order to open the one
source and access your macros from "All Open Workbooks" so to not have to
remember which file you used/saved it in previously?