Forum Discussion
Creating a manual toolbar in the VBE gets saved in position, but using VBA is deleted on exit
The manual way to add a VBE toolbar is via View, Toolbars, Customize, New, then give it a name. dock it with the other toolbars. When you exit Excel and then restart Excel, the toolbar name and position are saved with Excel. However, if you use VBA, like so: Set cmdMyBar = Application.VBE.CommandBars.Add("VBE", msoBarFloating, True, False) and then exit Excel, the toolbar disappears and doesn't return on load up. i think this is a question for a microsoft engineer to determine why this behavior happens.
Thoughts?
- A little help please
2 Replies
- BartH_NLCopper Contributor
Hi Dan,
you have marked this as Solved, but what was the solution? I currently have a similar situation on my work laptop... But even manual changes to the VBIDE (as well as programmed changes) are not stored in the register after closing Excel (or any other application).
- DanMcGBrass ContributorA little help please