Excel Worksheets Menu bar
Hi
Try
Application.CommandBars("Worksheet Menu Bar").Reset
this should set the main menu bar to its original state.
regards
Paul
Muk wrote:
Hi all
By mistake I deleted the Worksheets menubar ("View"). Now I want to restore
the same back but can't find solution. Next to File ,Edit...
I already tried the detect and repair but no success
I wrote folling in my code
cnt = Application.CommandBars("Worksheet Menu Bar").Controls.Count
For i = 1 To cnt
If Application.CommandBars("Worksheet Menu
Bar").Controls.Item(i).Caption = "MAIN MENU" Then
Application.CommandBars("Worksheet Menu Bar").Controls.Item(i).Delete
Exit For
End If
Next i
Any Solution !!
Muk
|