-
In Office 2003 and previous versions I have successfully used custom toolbars for users who need to use custom controls across multiple workbooks. For example, a user might open FileX, change a couple settings on the toolbar and then run an ODBC import from Oracle into FileX. User would then close FileX...
-
Those comments are almost identical to the comments in the CMS that I use (ExpressionEngine) so that should be easy to remember. Thanks again Nick. Much appreciated. Tim
-
Nick, That makes perfect sense. I was planning to try a few callbacks later today so I'll definitely give that a shot. Do you know if it is possible to add comments to the xml in CustomUI? I can easily see me revisiting my new exam template six months from now and having to completely relearn what...
-
Nick, Excellent! Thanks for that. It works perfectly. So, how does one know when to use <commands> and when to use <menu> or <button>? SheetMoveOrCopy is listed as a button in the ExcelRibbonControls.xlsx worksheet from Microsoft. There must be some logic to this, and you seem to have...
-
Tim You need the commands attribute of the customUI (as explained in step 3), so something like... < customUI xmlns ="http://schemas.microsoft.com/office/2006/01/customui" > < commands > < command idMso ="SheetMoveOrCopy" enabled ="false" /> </ commands...
-
Nick's posts on ribbon customization have been very helpful. However, I'm still having some difficulty. I wanted to disable most of the Save As choices on the Office button (except for .xlsm) and was able to figure that out. Now, though, I also want to disable the Move Or Copy Sheet command on...
-
I suspect the same as Mike, it should work with a menu, but suspect you will need to use a box or similar to group those controls. Unfortunately a bit pressed at the minute, but if it's not fixed this evening, I'll take a shot (UK time)
-
Going with the menu-in-a-ribbon structure, my first task is to build up some menus. I'm stumped here. So far I have managed to create the ribbon, the menu, and the menu buttons. So far so good. However, I can get the keytips to work for the ribbon and for the menu, but they fail to appear on the...