Buttons

Are you growing tired of locating your macro?  If you are like me, you have generated so many small macros that work together or work well on their own.  The problem is, when you have too many of them and a select few you consider your favorites.  Here is where a button comes in real handy.

In Excel 2010 you generate a button by clicking the down arrow near the office button here:

  

Choose customize, macros then select the macro you wish to have represented as a button:

Just like that and your button will appear as follows:

Right click on this button and you can now change the face to one of the available images.  Making this a customized button is a bit more involved but you can read further on this at http://blogs.msdn.com/b/excel/archive/2009/07/17/add-buttons-to-the-quick-access-toolbar-and-customize-button-images.aspx