Excel friends, I need your help!
I ran the old Explode Addin in Excel 2016 then my Add-In Menu Tab disappeared anytime I unload the Explode Add-In. The only way the Addin menu tab appears again is I load Explode again. So, I want to get rid of the Menu Bar with the Explode icon and keep my regular Add-In Tab. How can I get back my regular Menu?
The Explode code for the tabs is:
Private Sub Workbook_Open()
Application.CommandBars("Explode").Visible = True
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Explode").Visible = False
End Sub
Any help is highly appreciated!
I ran the old Explode Addin in Excel 2016 then my Add-In Menu Tab disappeared anytime I unload the Explode Add-In. The only way the Addin menu tab appears again is I load Explode again. So, I want to get rid of the Menu Bar with the Explode icon and keep my regular Add-In Tab. How can I get back my regular Menu?
The Explode code for the tabs is:
Private Sub Workbook_Open()
Application.CommandBars("Explode").Visible = True
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Explode").Visible = False
End Sub
Any help is highly appreciated!