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" wrote in message
...
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.

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" wrote in messag
..
Hello All. I have built a couple different VB addins the load when Exce
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 appears
The Problem I am having is getting rid of the da@! buttons out of th
toolbar 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 toolbar
I have searched the registry for a key that might be deleted to remove th
button (that no longer works) but to no avail
Can anyone give me some direction, please? My thanks in advance! Da
Grindstaff

The Problem I am having is getting rid of the da@!
buttons out of the toolbar after the Addin has been
removed.

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