PDA

View Full Version : [SOLVED] Make custom tab visible across all workbook



JKwan
02-18-2014, 03:35 PM
Wonder if people have XML accompany with vba to have custom tab visible across all workbooks? If I create an xlam, this the tab is visible across all workbooks, however, I only wanted xlsm. I try to create one, however, if I switched workbooks, my tab disappears and if I switched back, it comes back. I would like the tab to be visible all the time, thanks.

Bob Phillips
02-19-2014, 03:12 AM
I don't believe you can. If you have a custom tab in an xlsm, it is only visible when that workbook is active. I think that this is a fundamental principle of contextual tabs.

JKwan
02-19-2014, 07:54 AM
Thanks for your insight, xld. That would explained no matter what I tried, the tab keeps on disappearing on me.....

Andy Pope
02-20-2014, 09:59 AM
You can use namespace to have customUI shared across workbooks.

See Namespace example about 2/3rds of the way done the page.
http://www.andypope.info/vba/ribboneditor.htm

Bob Phillips
02-20-2014, 10:46 AM
But that still isn't all workbooks Andy, it is only for those selected workbooks.

Andy Pope
02-20-2014, 11:49 AM
If I open the namespacea.xlsm a new tab My Utils tab is displayed. If I then use CTRL+N to create a new workbook the tab is still displayed. Same if I open and existing file it still available.

JKwan
02-20-2014, 01:25 PM
Thanks Andy. I will denfinitely take a look at NameSpace.