rediffusion
Board Regular
- Joined
- Apr 24, 2019
- Messages
- 60
I added my add-in to Excel. Used "XML" to call from inside keytip="BP" and ******="ChooseTab". Running "MyExcelAddin.xlam" - It's WORK!
But! The fact is that after I go to the developer tab > Excel add-Ins = there I choose my add-in... When i open the add-in or any other Book, and boom doesn't WORK already! WTF I did not understand!?
Anyways does not work after setting the tick!![Check mark button :white_check_mark: ✅](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/2705.png)
Found on one portal StackOverflow, need to use "OnTime" instead of "Wait" or "Sleep". Seems like "Ontime" was not blocking the custom Ribbons from loading.
But I couldn't find the right code.
XML:
VBA:
P.S. :
"Office 2019"
"Microsoft Windows 10 Enterprise 2016 LTSB"
But! The fact is that after I go to the developer tab > Excel add-Ins = there I choose my add-in... When i open the add-in or any other Book, and boom doesn't WORK already! WTF I did not understand!?
Anyways does not work after setting the tick!
![Check mark button :white_check_mark: ✅](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/2705.png)
Found on one portal StackOverflow, need to use "OnTime" instead of "Wait" or "Sleep". Seems like "Ontime" was not blocking the custom Ribbons from loading.
But I couldn't find the right code.
XML:
HTML:
<!--?xml version="1.0" encoding="UTF-8" standalone="yes"?--><customui xmlns="http://schemas.microsoft.com/office/2009/07/customui" on Load="ChooseTab">
<ribbon startfromscratch="false">
<tabs>
<tab id="mytab_1" label="My Macros" keytip="BP">
<group id="Sheets" label="Листы">
<button
idMso="About"
label="Show About"
screentip="Bla bla bla"/>
</button
</group></tab>
</tabs>
</ribbon>
</customui>
VBA:
Code:
' (component: customUI, atribut: ******), 2010
Sub [B][COLOR=#2F4F4F]ChooseTab[/COLOR][/B](ribbon As IRibbonUI)
SendKeys "%BP{F6}"
End Sub
P.S. :
"Office 2019"
"Microsoft Windows 10 Enterprise 2016 LTSB"
Last edited by a moderator: