-
NameSpace Glitches?
Thanks Andy for helping me with http://www.vbaexpress.com/forum/show...s-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....
Last edited by JKwan; 02-21-2014 at 08:12 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...ong-workbooks/
I should have remembered that conversation, but I'm getting old.
-
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 :-).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules