Excel15.xlb

If you have commands appearing on the Add-ins tab they can be removed by deleting this file.


Common Scenario

Lets suppose you have created a custom toolbar and you have attached it to a workbook that will be distributed.
The first time the user opens the workbook the toolbar is displayed.
However when the user closes the workbook the toolbar is not removed.
When you close Excel this toolbar will be saved in the users (".xlb") file.
If the workbook toolbar gets modified at a later date then this user will see the old toolbar instead of the new modified one.
You must manually remove the toolbar and then attach the new one.
The same is true if you have have an old add-in that creates a toolbar and does not remove it correctly when the add-in is removed.
Is this still true if you create the toolbar with a Temporary=True setting.


File Location

Excel 365 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\Excel15.xlb 
Excel 2021 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\Excel15.xlb
Excel 2019 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\Excel15.xlb
Excel 2016 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\Excel15.xlb
Excel 2013 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\Excel15.xlb
Excel 2010 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Excel\Excel14.xlb
Excel 2007 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Excel\Excel12.xlb.
Excel 2003 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Excel\Excel11.xlb.
Excel 2002 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Excel\Excel10.xlb.
Excel 2000 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Excel\Excel9.xlb.

Important

There is no way in VBA to attach and detach toolbars from workbooks or documents


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext