I've attached my sample project. It has a menu which shows on the add-ins tab. With your code, I can't seem to give focus to it. I'm sure I missing something easy.
I've attached my sample project. It has a menu which shows on the add-ins tab. With your code, I can't seem to give focus to it. I'm sure I missing something easy.
Last edited by DocAElstein; 07-11-2023 at 11:59 AM.
Hello,
How To Activate A New Ribbon Tab.xlsm
This is the example that I tried in Excel 2007.
You asked me to start a new thread but the button to do so is not available. According to manual I do not have the rights probably. I have registered.
If you open the example it creates the custom tab but gets an error 91 because the ReturnElement has value Nothing and cannnot call its method. In my opinion this is caused because GetAccessible does not find the custom tab in the control tree.
Can you look into this example in spite of the fact that I did not create a new Thread?
Thanks
Rob Kemper
This ??
"How To Activate A New Ribbon Tab.xlsm" : https://app.box.com/s/h7om86vsnnsync61skxsb5npi8lllck6
Alan
( from post #6 :
"How To Activate A New Ribbon Tab 2010.xlsm" : https://app.box.com/s/ffvd87cvbz2qny3w5encd4hb8is893s4 )
….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
If you are my enemy, we will try to kick the fucking shit out of you…..
Winston Churchill, 1939
Save your Forum..._
KILL A MODERATOR!!
Bookmarks