Macros Menu in Excel 2007
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. |
Macros Menu in Excel 2007
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. |
Macros Menu in Excel 2007
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. |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com