What if the Excel menu bar and toolbar are missing?

Excel is an office of the necessary software, when you open Excel found excle menu bar and toolbar disappeared, it must be very worried? This problem many friends have met, next, for you to introduce the solution.

As shown in the following illustration, the menu bar and toolbar are gone:

1. Open an Excel file, press ALT+F11, and then click Insert in the Open Window--module, as shown below:

Copy the following font to the dialog box:

Sub aaa ()

Dim AA, BB as Boolean

AA = True

BB = False

Application.CommandBars ("ply"). Enabled = AA

' Right-click sheet tab is available

Application.CommandBars ("Cell"). Enabled = AA

' Right-point cell is available

Application.CommandBars ("toolbar list"). Enabled = AA

' Right-click ' toolbar and ' view '-' toolbar ' is available

Application.CommandBars ("AutoCalculate"). Enabled = AA

' Right-click ' status bar is available

Application.CommandBars ("Worksheet menu bar"). Enabled = AA

Application.CommandBars (1). Enabled = AA

' The effect of the above two sentences is to cancel the menu

Application.CommandBars (2). Enabled = AA

' Temporarily unknown

Application.CommandBars (3). Enabled = AA

' Common toolbars are available

Application.CommandBars (3). Controls (3). Enabled = AA

' Make the third ' save ' available in a common toolbar

Application.CommandBars (4). Enabled = AA

' Formatting toolbar is available

Application.CommandBars (5). Enabled = AA

' Temporarily unknown

Application.CommandBars (1). Enabled = AA

' Restore menu available

Application.CommandBars (1). Controls (1). Enabled = AA

' Make file ' available on menu

Application.CommandBars ("File"). Controls ("Page setup (&u) ..."). Enabled = AA

' Menu, ' Page Setup ' in file ' is available

Application.CommandBars (1). Controls (4). Enabled = AA

' Fourth Insert ' in the menu is available

Application.CommandBars (1). Controls (4). Caption = "Victor"

' Change name

Application.CommandBars (1). Reset

' Restore Menu

Application.displayformulabar = AA

' Does the formula bar show

Application.displaystatusbar = AA

' Status bar is displayed

Activewindow.displayheadings = AA

' Row number column labels show

Activewindow.displayworkbooktabs = AA

' Sheet tabs Show

Activewindow.displayhorizontalscrollbar = AA

' Horizontal scroll bar is displayed

Activewindow.displayverticalscrollbar = AA

' Vertical scroll bar ' shows whether

End Sub

OK, then press F5, run the macro AAA, and then close, back to Excel you can see the toolbar and so on again.

What to do if the