Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 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 at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On 24 juil, 19:10, GS wrote:
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 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 Many thanks "One possibility is that the projects using the toolbars did not remove them at shutdown" was indeed the problem Avi |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
avi laid this down on his screen :
On 24 juil, 19:10, GS wrote: 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 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 Many thanks "One possibility is that the projects using the toolbars did not remove them at shutdown" was indeed the problem Avi You're welcome! Glad to help... -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stubborn cell formatting. | Excel Worksheet Functions | |||
Stubborn Excel Options | Excel Programming | |||
Stubborn Date Format | Excel Programming | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
stubborn macro | Excel Programming |