Removing Addin Buttons on Toolbars

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All. I have built a couple different VB addins the load when Excel starts and insert a 'button' with a title at a specific place in the toolbar, such as under 'Tools'. The user can then drop-down 'Tools', select the addin button, and my form appears.

The Problem I am having is getting rid of the da@! buttons out of the toolbar after the Addin has been removed. When you are testing several versions of an addin either by installing it as an app or just registering the DLL, it would be nice to clean the button out of the Excel toolbar. And certainly this will not do if a customer wants to uninstall and my (no longer working) Addin button is still in the toolbar

I have searched the registry for a key that might be deleted to remove the button (that no longer works) but to no avail

Can anyone give me some direction, please? My thanks in advance! Dan Grindstaff.
 
Dan,

Two ways,

remove it on close

make it a temporary control

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dan Grindstaff said:
Hello All. I have built a couple different VB addins the load when Excel
Click to expand...
starts and insert a 'button' with a title at a specific place in the
toolbar, such as under 'Tools'. The user can then drop-down 'Tools', select
the addin button, and my form appears.
The Problem I am having is getting rid of the da@! buttons out of the
Click to expand...
toolbar after the Addin has been removed. When you are testing several
versions of an addin either by installing it as an app or just registering
the DLL, it would be nice to clean the button out of the Excel toolbar. And
certainly this will not do if a customer wants to uninstall and my (no
longer working) Addin button is still in the toolbar.
I have searched the registry for a key that might be deleted to remove the
Click to expand...
button (that no longer works) but to no avail.
Can anyone give me some direction, please? My thanks in advance! Dan
Click to expand...
Grindstaff.
 
The Problem I am having is getting rid of the da@!
buttons out of the toolbar after the Addin has been
removed.
Click to expand...

Yu have to "delete" each and every one, perhaps in
your "Before_Close" routine, thus :

e.g.
On Error Resume Next
Application.CommandBars("Alignment").Controls
("Project").Delete
 
Thank you. I was also wondering if there were a location in the registry were several such 'garbage' toolbar entries might be deleted (i.e. previous tries at the addin's name)
----- Bob Phillips wrote: ----

Dan

Two ways

remove it on clos

make it a temporary contro

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

Dan Grindstaff said:
Hello All. I have built a couple different VB addins the load when Exce
Click to expand...
starts and insert a 'button' with a title at a specific place in th
toolbar, such as under 'Tools'. The user can then drop-down 'Tools', selec
the addin button, and my form appearstoolbar after the Addin has been removed. When you are testing severa
versions of an addin either by installing it as an app or just registerin
the DLL, it would be nice to clean the button out of the Excel toolbar. An
certainly this will not do if a customer wants to uninstall and my (n
longer working) Addin button is still in the toolbarGrindstaff
 
Back
Top