Showing related tags and posts accross the entire site.
-
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...
-
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...