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/ar...me-simple.aspx



On 05/18/2010 08:27, JD McLeod wrote:
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.

See
http://www.rondebruin.nl/qat.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"JD McLeod" wrote in message ...
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.