Macros Menu in Excel 2007

  • Thread starter Thread starter JD McLeod
  • Start date Start date
J

JD McLeod

I need to create a series of macros in a spreadsheet. The purpose is simple,
when the macro is initiated all it will do it to insert in the active cell a
symbol of a specific color and bold text. There will be about 30 different
macros for users to choose from, since there will be about 30 different
symbols used in this project. How is the best way to go about doing this?
In old Excel, i could create a custom menu and add the macro to it. Is there
another way other than having to use RibbonX? thanks.
 
You can still create the custom menu in xl2007. But it won't float. It will
appear in the Addins tab on the ribbon.

You could modify the ribbon or QAT:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx
 
Back
Top