PDA

View Full Version : [SOLVED] NameSpace Glitches?



JKwan
02-21-2014, 07:50 AM
Thanks Andy for helping me with http://www.vbaexpress.com/forum/showthread.php?48963-Make-custom-tab-visible-across-all-workbook
The NameSpace does make my tab show up across Excel. Now, there is only a minor cosmetic issue, it is no big deal, but if anyone can help.... Thanks in advance

Basically, I have icons on my tab show label = false. These icons are the standard icons from Excel, like Copy, Paste, New File, etc. When I first open up my file, there is no labels, this is what I want. Now, I open a file, I switched to the "universal" tab, my icons have labels??? I switched to the file that I loaded, close that file, I now click on my tab, the labels disappear?

I also discovered that my button no longer works. I guess it makes sense because I need to explicitly tell the ribbon where to execute the macro. I tried and failed miserably. With the old days, I use the "Application.Run xxx!macro". With ribbon, how do i code it? It must be with the OnAction line....

Andy Pope
02-24-2014, 06:41 AM
Looks like you are fighting a losing battle with this.

Have a read of this to see that although the buttons are shared they don't actually function.
http://www.excelguru.ca/blog/2007/03/19/sharing-a-custom-ribbon-tab-among-workbooks/

I should have remembered that conversation, but I'm getting old.

JKwan
02-24-2014, 07:02 AM
Nah, I would not call it a losing battle, however, I will say this, I thought it would be easier.... only it is not!

Thanks for the article, Andy. During the weekend, I did find that article. I read it and I was hoping that I would not need an add-in solution.... Sounds like that is the only way out? If this is the case, I might as well stick to my current solution, just an add-in. I thank you for your help. The good is that I learnt about the NameSpace, so, it is not a total devastation :-).