Custom Menu return to Excel Menu upon Closing
I would like to find out if there is a way to modify the following code to
restore the Excel Menu upon exiting the file.
Your help would be sincerely appreciated!
____________Code Below ________________________
Private Sub CommandButton1_Click()
' Remove commandbars
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Next
|