Excel and the menu bar

[gazzanewpy]

Strange but the menu bar has completely disappeared from Excel! The user loaded a spreadsheet and since then the file/edit menu has completely gone!

I cannot find any embedded macros within Excel nor can I find a simple activation button gor the menu bar so how do I get it back? I presume it's via macro coding but slightly puzzled.

 

[GlennUK]

Where have you looked for the embedded macros?

Have you looked at all of the Excel objects to see if there are any event driven macros ( such as the Workbook object whch might have a Workbook_Open subroutine, and so on )?

To see such code use the VBE and right click an object and choose View Code from the shortcut menu.


Hope that helps.

Cheers, Glenn.

 

[gazzanewpy]

Thanks for this but yes, I have already undertaken this code check - though I will doublecheck because it does feel like a coding issue (a remnant if you will). It simply looks like this other spreadsheet file has deleted the entire menu bar.

 

[TonyJollans]

Hi gazzanewpy,

First, you can't delete built-in menus; to get it back you should be able to code (in the immediate window if you like) ..

[blue][tt] Application.CommandBars(1).Enabled = True[/tt][/blue].

To find out what code is running when you open a workbook, you can open it from code and single step. In a standard code module, enter ..

[blue]Sub Test()
    Workbooks.Open "C:\Documents and Settings\Tony\Desktop\Book2.xls" [green]' Your File Name here[/green]
End Sub[/blue]

Then single step the code - with the cursor in the routine, press F8 once per instruction and it will take you through whatever it does.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.