Daily posts of Excel tips…and other stuff
Archive for the ‘CommandBars’ Category.
Many of my spreadsheets use Excel 2003 Commandbars for application control.
Having loaded these spreadsheets into Excel 2007, I see my commandbars presented on the Add-In tab of the Ribbon.
I’m a late starter with Excel 2007 ribbons, but I guess it’s time to move.
I’ve found that the various guides on the Internet tend to throw you [...]
I have a workbook with 131 worksheets in it (one for each inventory item). It is a terrible design, but it’s a non-trivial task to make it right, so I haven’t done it yet. Instead, I’m making little macros to make working in this monstrosity livable. I have a macro to build [...]
CommandBarButtons have a ShortcutText property that you can use to list a command’s shortcut next to its menu item. The Cut menu item has Ctrl+X listed next to it.
In this example, I make a new menu with one item under it. OnKey is used to assign a keyboard shortcut and the ShortcutText property [...]
I’m creating several add-ins that will all use the same top-level menu item. The add-ins will be installed as needed. So someone may have just one and someone else may have half a dozen. The right answer, I think, is to have one controlling add-in that handles the menus (and not much [...]
Hi all
When you open your Excel 97-2003 file in Excel 2007, one that creates its own menus,
the first thing you notice is that you don’t see your menus. Where’d they go? Then you discover
them - shunted over on the Add-ins tab. Not exactly the ideal user interface.
How are your users going to [...]
You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated.
What to do? The only way I find to be reliable is to catch all possible paste operations. But this isn’t very easy, [...]
Mike Alexander has updated his table driven Ribbon customizer. You can find it here:
http://www.datapigtechnologies.com/Custom_UI_Builder.zip
He says:
The utility now creates and adds a module with all the call-back functions to the newly created buttons, allowing the buttons to work right away.
As always, the source code is open for anyone who wants to build on this [...]
Hi all
I add two pages to my site to create a menu in Excel 2007.
I changed John Walkenbach‘s superb menu maker example for 97-2003 to create the PopUp menu.
Very easy to add and edit menu items with this technique.
For one workbook
http://www.rondebruin.nl/qat2.htm
Menu for all your workbooks
http://www.rondebruin.nl/qat.htm
Suggestions are welcome
Ron de Bruin
http://www.rondebruin.nl/tips.htm
