Excel menu bar missing Solved

Question

Hello,

I just downloaded an Excel sheet and since then I have no menu or toolbar on my session.
I cannot restore the toolbars because I have no access to anything (just the formula bar).
My restorations are not working and reinstalling my Office package is the same. However, there are no issues on other sessions.

Can you please tell me how to restore a lost menu bar?

Thank you in advance

Configuration: os: windows XP home

Didi · Accepted Answer

Hi,

I had the same problem as you just yesterday and the link provided above for restoring the toolbar worked perfectly.

To access Visual, you press Alt-F11. There, you click on ThisWorkbook and copy the macro provided in the link. That is to say, the following:
Sub ResetCommandBars()
Dim x
On Error Resume Next
For x = 1 To Application.CommandBars.Count
With Application.CommandBars(x)
.Reset
.Enabled = True
End With
Next x
End Sub

All you need to do is run it and it works.

Erdnax · Answer

Hi,

Where did you download your Excel sheet from? It might be a macro that has disabled everything for you and protected it like that...

To get an idea of what VBA can do, http://www.excelabo.net/xl/protection.php#afficheffacebarres

Then, go to your hard drive where you installed Office (by default: C:\Program Files\Microsoft Office\), then navigate to Office\XLStart\Perso.xls (if it doesn't exist, then it's not from that...) and check in the macros if there might be one that is blocking your interface.

See you later

--
P'tit Suisse

lawre · Answer

Thank you for your response.

There is no perso.xls.
Furthermore, I must admit that I downloaded about ten Excel sheets and tried them out, deleting them one by one as they didn't interest me. So I'm unable to say which sheet is causing the issue; in fact, I don't even remember their names, and anyway, I've deleted them.

Since Excel works on my other sessions, how can I restore my menu and toolbar?

Thank you for helping me; I'm really stuck here!
Have a great day, everyone.

Erdnax · Answer

try the various tips presented on this page:

http://www.excelabo.net/xl/plantages.php#restaurerBO

and on this one too:

http://www.excelabo.net/xl/barres.php#disparition

see you soon

--
Little Swiss

lawre · Answer

Thank you for your information.
But it's not of great help to me because it's not just my toolbar that disappeared, but also my menu bar. So I couldn't save a macro (no button anymore) or open the code window to write macros.
So there was no way to execute the advice (yes, I looked up and right-clicked. I've never seen restore in the context menu.
But I managed to recover a file that restores everything to the initial state.
If someone wants it... I'll make it available.

Thank you, Erdnax. Have a nice day...

Pakou · Answer

I tried it at home. It works!!! I had been dealing with this problem for months. Thank you so much.

Macleod · Answer

Thank you very much for the step-by-step guide with VB.
I had the same problem and it’s FINALLY resolved... :)
What a relief, I was pulling my hair out last night until 2 a.m. and this morning since 7 a.m.
I didn't want to give up!! :/
Even reinstalling the complete Office package didn’t help at all.

So:

A BIG THANK YOU

flofredetc · Answer

Hello everyone, I have the same problem, my menu bar has disappeared in Excel. If I press Alt + F11, I open Visual Basic, but I don't have this workbooks.
I don't know what to do anymore, if someone can help me.

kelkel · Answer

Thank you very much for the tip, it works wonderfully. I've been trying to recover that menu bar for months. Thank you for the detailed steps and the code to copy.

vwtroudy · Answer

A BIG CONGRATULATIONS, THANKS TO YOUR MANIP:
"
Sub ResetCommandBars()
Dim x
On Error Resume Next
For x = 1 To Application.CommandBars.Count
With Application.CommandBars(x)
.Reset
.Enabled = True
End With
Next x
End Sub
"

I WAS ABLE TO SHOW IT OFF IN FRONT OF A COLLEAGUE WHO JUST HAD THE SAME PROBLEM!!!!!

Lacide · Answer

Thank you for your solution DIDI!!! It's really great and it's working amazingly;)))) Thanks a lot!

pluton69 · Answer

Hello everyone   A HUGE THANK YOU to Didi for your help. Really amazing, it works.

toni · Answer

Hello, It's simple, it works, thank you!!

vengeurz · Answer

Hello everyone,
I had the same problem and I tried the solutions mentioned above. I have Outlook 2003 and I feel like the little VB program wasn't working, or maybe I was doing something wrong.

After searching a bit... with a bit of logic... I went to the menu: view / formula bar; and it wasn't checked.
guess what happened next...: I checked it!!!
OOOOh miracle ... it reappeared ;o)

Have a nice Sunday everyone!

allamezon · Answer

Hello,
I’m sorry to disappoint you, but I haven’t been able to find my "standard" toolbar even with your miracle macro.
I don’t understand anything because I don’t feel like I did anything particular.
I need help because it’s only the "standard" toolbar that has disappeared, and I’ve checked that the box is checked.
See you,
Sébastien

allamezon · Answer

I forgot to tell you that I am on Mac OS 10.3.9...

okisone · Answer

Hello,

thank you so much....You just saved me from a looming professional disaster :))
(Note for later, never mess with the Excel menu bars again, as it affects everyone.. and keep this magical piece of code in mind)
Well done and thanks again

douggy · Answer

Hello allamezon,
If the problem persists, have you tried:
Right-clicking on the menu area
Selecting customize
Underneath the two drop-down windows, clicking on the box to rearrange commands
At the top, there are two options: menu bar and toolbar with a small button in front
Click the button in front of toolbar and select "STANDARD"
At the bottom left, click reset and confirm
This should resolve the issue.

Scan le Gentil · Answer

Perfect, super efficient the piece of code. Thank you Didi

Shakawe · Answer

If there were a tip awards, I would give you the first prize for excellence; your tip will stand the test of time, you deserve a trophy... thank you for your help.... :)

Mathieu · Answer

Thank you very much! Your solution saved me a lot of time!! :)

liliBlul · Answer

Thank you for the tip!!! You saved my workstation!

krakott · Answer

Personally, I tried everything: in vain. And now I just found the solution to my problem (Office 2003)... it's quite simple, my menu bar had just slid all the way to the bottom of my page...  I'm mentioning this for future reference because I've been searching for a while... in vain.

xavier paris · Answer

Hi!  I encountered the same issue (opening an Excel file with macros) which caused my Excel formula bar to disappear.  The solution is simple and doesn't require any VBA code or anything!  Go to Menu Options > View tab > then in the Show group, check Formula Bar again.  You're all set!

VampirX · Answer

Hello,  otherwise, just delete the .xlb file from your profile in documents and settings to reset Excel's customizations and restore toolbars and menus.

denise saint pierre · Answer

Hello, I am on Mozilla Firefox and my menu bar has disappeared, what can I do? Thank you for your response, best regards.

jmp59 · Answer

Coming into a discussion that dates back over 5 years to ask for help is surely not the best way!  --  To err is human, to persist is diabolical.

cvfaf23 · Answer

Here's the translation:

Open Excel Click on Alt+F11, the Visual Basic panel opens Add a module and inside the module paste the following text, then run the module, and voilà the menus appear.  -+-+-+-+-+-++ Sub Sesame()  For Each CmdB In Application.CommandBars  CmdB.Enabled = True  Next CmdB  With Application  .DisplayFullScreen = False  .DisplayStatusBar = True  .DisplayFormulaBar = True  End With  With ActiveWindow  .DisplayWorkbookTabs = True  .DisplayHeadings = True  End With  End Sub -+-+-+-+-+-  Thanks to everyone

crakis · Answer

Hello,  Here is a simple and quick method to restore all the menus (File, Edit, etc.) that have disappeared in EXCEL 2003:  1/ You need to start EXCEL in safe mode. To do this, go to "Start" then "Run" and type excel /s (with a space between excel and /s)  2/ EXCEL starts in safe mode with the menus. Click on the "?" tab and then click on "Detect and Repair"  3/ Check the 2nd box (reset my settings....) then click on Start.  4/ A message asks you to close EXCEL, close it and then click on "Retry"  Restart Excel normally and your menus are all back now!  @+

Omar · Answer

Thank you so much, I managed to fix my problem with the macro:  Sub ResetCommandBars() Dim x On Error Resume Next For x = 1 To Application.CommandBars.Count With Application.CommandBars(x) .Reset .Enabled = True End With Next x End Sub  Thank you

Excel menu bar missing

30 réponses

Windows spotlight is not working.

Samsung j5 unable to answer

Scam of the suvedene highway

Remove 360 antivirus

My pc's screen is flickering.

Fujitsu siemens laptop won't start anymore

Wearline: what do you think?

Eko tank smartwatch

Ibiza sound reviews

Only one of my iphone headphones works. what to do?