Attaching Toolbars


Excel

Excel's approach to storing toolbars can cause a few problems.
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.
Therefore 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.
Is this still trueif you create the toolbar with a Temporary=True setting ??


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