Showing related tags and posts accross the entire site.
-
So couple of more limitations of the great Ribbon 1. Gallery Lables cant be set to False 2. Groups can be added only to the QAT and not to custom tab
-
Hi Andy... Yes I did the same thing... Group Button : - Example on the Home Tab you have for Example "Clipboard" group - If You right Click and say Add to QAT - It is reduced to a single Group control button... I want to add a built in group control to a Toolbar on a Custom Tab
-
Two Questions 1) Does any one know Why this bit of XML does not give the expected results - It continues to displays the Label <gallery idMso="ControlsGallery" showLabel="false"/> 2) How Do you add a Group Button to a Toolbar on a Custom Tab TIA Sam
-
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 have, via the blog contact form received three questions from Milan, these were Can you remove the Office Button? Can you link a combobox (on the ribbon) to a cell/range? Can you link a label (on the ribbon) to a cell? The answer to No.1 was answered in the 2nd of my series on customising the ribbon...