Stubborn toolbar

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Hello,

Excel 2010 loads automatically 2 pld toolbars in the add-in tab
whatever I do

I've looked everywhere in all possible directories (xlstatrt, addins
in office, c:/users....) but did not find any trace of the toolbars

Is there anything I can do to remove the toolbars? What could trigger
Excel to load them even if no workbook is opened and they do not
appear in the projects vba?

Thanks

Avi
 
After serious thinking avi wrote :
Hello,

Excel 2010 loads automatically 2 pld toolbars in the add-in tab
whatever I do

I've looked everywhere in all possible directories (xlstatrt, addins
in office, c:/users....) but did not find any trace of the toolbars

Is there anything I can do to remove the toolbars? What could trigger
Excel to load them even if no workbook is opened and they do not
appear in the projects vba?

Thanks

Avi
Click to expand...

One possibility is that the projects using the toolbars did not remove
them at shutdown.

Another possibility is that they're custom toolbars 'attached' to
workbooks and also they were not removed when the attached workbook
closed.

Another possibility is that Excel crashed while the toolbars were in
use, and so have been added to the tlb file.

Try deleting the toolbars, close Excel, reopen Excel and see if they
persist. (This may require looping the CommandBars collection to
generate a list of their names)

It's also possible they belong to ComAddins and so will not appear in
the VBE.
 
After serious thinking avi wrote :





One possibility is that the projects using the toolbars did not remove
them at shutdown.

Another possibility is that they're custom toolbars 'attached' to
workbooks and also they were not removed when the attached workbook
closed.

Another possibility is that Excel crashed while the toolbars were in
use, and so have been added to the tlb file.

Try deleting the toolbars, close Excel, reopen Excel and see if they
persist. (This may require looping the CommandBars collection to
generate a list of their names)

It's also possible they belong to ComAddins and so will not appear in
the VBE.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

Many thanks

"One possibility is that the projects using the toolbars did not
remove
them at shutdown" was indeed the problem

Avi
 
avi laid this down on his screen :
Many thanks

"One possibility is that the projects using the toolbars did not
remove
them at shutdown" was indeed the problem

Avi
Click to expand...

You're welcome! Glad to help...
 
Avi

This may be triggered via a registry key, I don't know which one exactly,
but it may be worth exploring that as a possible culprit.

HTH
Mick
 
Hello,

Excel 2010 loads automatically 2 pld toolbars in the add-in tab
whatever I do

I've looked everywhere in all possible directories (xlstatrt, addins
in office, c:/users....) but did not find any trace of the toolbars

Is there anything I can do to remove the toolbars? What could trigger
Excel to load them even if no workbook is opened and they do not
appear in the projects vba?

Thanks

Avi
Click to expand...

Several solutions: right click on the toolbars and select the delete
option. If they re-appear when you re-open Excel, then do File (Office
button in 2007), Options, Add-ins. On the right click Go beside
"Manage Excel Add-ins". Uncheck add-ins that are checked. Repeat but
change the dropdown to "Manage COM add-ins". If you need one of the
checked add-ins, obviously keep it.

If that doesn't sole, use the XLB File Deleter at
http://www.add-ins.com/xlb_file_deleter.htm and see if deleting the
toolbar file solves.

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Maybe this is irrelevant but I do remember having once stubborn
toolbars appear unwantedly.
So I had to run below code before activating the worksheet. Rgds.

Sub delbar()
Application.CommandBars("Standard").Visible = True
Application.CommandBars("Standard").Visible = False
End Sub
 
Back
Top