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....
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....