I have recently converted to Office/Excel 2010. I am extending and maintaining an application I created in Excel/VBA 2003. I need some high level design advice for dealing with a tool bar that I dynamically created via VBA 2003. This tool bar is part of a multi workbook application. The VBA macro that creates the tool bar runs out of the auto-open macro in a Personal workbook. If any of the participating workbooks in the application are found to be open (were clicked causing the macro to run) , the macro creates the desired tool bar with buttons that are linked to necessary macros that support the application. If none of the participating workbooks are the one clicked, the start-up macro checks to see if the tool bar is already there and deletes it and if not, it just exits. The button face numbers and the to-be-linked macro names are stored in a table within the Personal workbook.
All that said, it works mostly fine as I installed Excel 2010 ,except that the buttons are hidden on the Add-Ins ribbon as a custom tool bar.
I would like the buttons to be more prominent in their 2010 reincarnation! If possible, I would also like to maintain their table driven definition and create whatever replacement via VBA.
To properly exploit Excel, 2010, what is the proper 2010 resource to use? It appears that tool bars in 2010 have been relegated to being second class citizens, offered as (mere) add-ins and given second class real estate
Can I create ribbons under VBA? On the ribbon, can I create a group with buttons ? Can the buttons be linked to macros? If this is possible, is this the proper resource to use?
Across the application there are other worksheet specific macros linked by objects embedded in specific respective worksheets. However, the ones I am questioning in this post are buttons (and their linked macros) that need to be available across workbooks and worksheets.
Any advice would be appreciated.
Bookmarks