paul.robinson
12/14/2006 9:50:00 AM
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