Questions tagged [excel-iribbonui]
6 questions
2
votes
1 answer
"Run-time error '1004' Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command" When using "onLoad" in Ribbon XML
I have a feeling I'm using the "onLoad" callback incorrectly. Essentially what I'm trying to do is run some code in VBA immediately after my custom ribbon loads (which is located on an add-in I've created).
This is the XML code:
Jon Rose
- 129
- 2
- 8
2
votes
2 answers
Excel Custom RibbonUI; Add Section Title for Menu
Im running 2016 Standalone Excel (32bit version). I've been building a custom ribbon and so far so good. The documentation is pretty fluid and well written. However, I cant find any way to include menu 'section titles' as seen below:
Specifically…
soulshined
- 9,612
- 5
- 44
- 79
1
vote
1 answer
UI Ribbon: How to unpress a toggle button?
There are 4 toggle buttons, when I be click on one, the other 3 are not clicked
For example, when I click public, Confidential's Click will be removed. Only 1 can be selected.
Mehmet Ceylan
- 186
- 9
0
votes
1 answer
AddIn IRibbonUI callbacks and .Invalidate fails after it installs any other AddIn with its own IRibbonUI
Description: This is Excel 2013 VBA case. I created AddIn which should be able to install and uninstall another AddIns from AddIn list stored in global variable "listOfAddIns" which is Array of Arrays of Variant Type called "valueArray". There are…
RosMane
- 21
- 3
0
votes
0 answers
Cannot execute macro module
I am currently working on creating my own Ribbon in excel. I wrote out the specific code in a module in a macro-enabled workbook that I will subsequently save as an Excel add-in (.xlam). However, whenever I try to run the module in my macro enabled…
S_Z
- 35
- 4
0
votes
1 answer
IRibbonUI document load event
I'm wondering if someone can help me out with a VBA issue -- I haven't written VBA in over 20 years and I'm stuck.
I've created a ribbon button and I need the button greyed out if a word document is open from a local drive or file share. I need the…
