Macros Menu in Excel 2007
in [Programming]
|
Prev: Nested If Function to be converted into a user-defined custom function
Next: Dynamic VBA for dynamic Forms
From: JD McLeod on 18 May 2010 09:27 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.
From: Dave Peterson on 18 May 2010 10:16 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 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.
From: Ron de Bruin on 18 May 2010 11:15
See http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JD McLeod" <JDMcLeod(a)discussions.microsoft.com> wrote in message news:D0F74BAF-D1DB-4A08-BDC4-D2A2F8F0844D(a)microsoft.com... > 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. |