Hide/Restore Excel Toolbars in Excel VBA. Show/Hide a Custom To…
https://www.ozgrid.com/VBA/toolbar-remove-restore.htm
Show/Hide Custom Toolbars & Remove/Restore Excel's Native Toolbars Open the Workbook that should have the custom toolbar. Right click on any grey unused part of any toolbar and choose "Customize". On the "Toolbars" page check "MyToolbar" (or the applicable name) so it becomes visible. Click "Attach" and then from the "Attach Toolbar" dialog select your toolbar and then click "Copy".
Open the Workbook that should have the custom toolbar.
Right click on any grey unused part of any toolbar and choose "Customize".
On the "Toolbars" page check "MyToolbar" (or the applicable name) so it becomes visible.
Click "Attach" and then from the "Attach Toolbar" dialog select your toolbar and then click "Copy".
DA: 18 PA: 48 MOZ Rank: 46