amitkumarsony2412
New Member
- Joined
- Sep 13, 2010
- Messages
- 8
Hi Friends,
I've made two excel addins for excel 2007 version. When its load, automatically add a tab called utilities.
I want to know...
1.) Whether we can check its installed or not from vba code.
2.) If its installed then want to add some more group in the same tab.
3.) It its not installed yet, then create new tab called utilities.
I know how to add a new tab or add commands in an existing tab, but I'm not able to check for existing tab's load status
When i load my first addin its working successfully, but when i installed the second addin its make an new tab with the same name.
Here's my code for Ribbon Tab :
<?XML:NAMESPACE PREFIX = [default] http://schemas.microsoft.com/office/2006/01/customui NS = "http://schemas.microsoft.com/office/2006/01/customui" /><customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"><customUI xmlns="<a href=" target=" target=" http: _blank? forum www.mrexcel.com><ribbon>
<tabs>
<tab id=TbUtilities label="Utilities">
<group id=Grp1 label="MyGroup">
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="TbUtilities" label="Utilities" >
<group id="Grp1" label="MyGroup">
<button id="Btn1" label="Start Data Extraction" size="normal" onAction="OnCall" image="Import" />
<button id="Btn2" label="Settings" size="normal" onAction="OnCall" image="Settings" />
</group>
</tab>
</tabs>
</ribbon>
</customUI></group></tab></tabs></ribbon></customUI>
</customUI>
I've made two excel addins for excel 2007 version. When its load, automatically add a tab called utilities.
I want to know...
1.) Whether we can check its installed or not from vba code.
2.) If its installed then want to add some more group in the same tab.
3.) It its not installed yet, then create new tab called utilities.
I know how to add a new tab or add commands in an existing tab, but I'm not able to check for existing tab's load status
When i load my first addin its working successfully, but when i installed the second addin its make an new tab with the same name.
Here's my code for Ribbon Tab :
<?XML:NAMESPACE PREFIX = [default] http://schemas.microsoft.com/office/2006/01/customui NS = "http://schemas.microsoft.com/office/2006/01/customui" /><customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"><customUI xmlns="<a href=" target=" target=" http: _blank? forum www.mrexcel.com><ribbon>
<tabs>
<tab id=TbUtilities label="Utilities">
<group id=Grp1 label="MyGroup">
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="TbUtilities" label="Utilities" >
<group id="Grp1" label="MyGroup">
<button id="Btn1" label="Start Data Extraction" size="normal" onAction="OnCall" image="Import" />
<button id="Btn2" label="Settings" size="normal" onAction="OnCall" image="Settings" />
</group>
</tab>
</tabs>
</ribbon>
</customUI></group></tab></tabs></ribbon></customUI>
</customUI>
Last edited: