Daily posts of Excel tips…and other stuff
Archive for the ‘Toolbars’ Category.
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 [...]
The COM Add-in (Component Object Model) toolbar button is not on any toolbars by default. You have to add it and then click on it to get to the COM Add-in dialog. First, right click in a blank area around the toolbars and choose Customize
Go to Tools on the left and COM Addins [...]
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 [...]
So Dick is the keyboard guru here, but there’s a lot of people that use the mouse a lot. I know I do. And I was reading Jensen Harris‘ blog today about how a Paste Special operation takes 6 clicks right now, but only 3 in Office 12.
However, there are a number of [...]
Some toolbar popups can be undocked and made to be their own toolbar. This is useful if you need temporary, but constant, access to certain tools. To undock, click on the bar that runs across the top of the popup.
Such as a shapes popup from the Drawing toolbar
Or the borders popup from the [...]
Brett points out that Excel has a rudimentary icon editor. Right click on a toolbar button and choose Customize to enter Customize Mode. Then right click on the button again and choose Edit Button Image…
You get a 16 x 16 grid in which you can create your own icon. Here’s one that [...]
