Jun 18 2022 12:50 PM
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?
Jun 19 2022 07:57 AM
SolutionJun 19 2022 07:57 AM
Solution