Show Menu Bar

[tqm1]

Dear Experts

When I run Excel then it has Standard Toolbar and Formatting Tollbar but there is no Standard Menu bar. I mean the bar that contains (File, Edit, View, Insert,Format,Tools, Date,Window, Help) is not present.

Please help

[lucas]

right click on any of the toolbars and select customize
Under the toolbars tab make sure worksheet menubar is checked

[Bob Phillips]

or just do

Application.Commandbars("Worksheet Menu Bar").Enabled = True

in the VBIDE immediate window

[tqm1]

I have run this command
<FONT style="BACKGROUND-COLOR: #ebffeb">

Application.Commandbars("Worksheet Menu Bar").Enabled = True

But it shows Chart Menu Bar instead of Worksheet Menu Bar.

There is Chart pad instead of Data pad.
There is no Delete command in Edit menu.

Pleaes help

[mikerickson]

Have you tried Resetting the menu bars from their dialog box?

[tqm1]

Yes, but failed to get actual worksheet menu bar

[lucas]

have you added any code to your thisworkbook module in your personal.xls

do you have any files in your startup directory with code that runs on startup that might be disabling your menu?

[Bob Phillips]

ACtivate a worksheet not a chart sheet.

[tqm1]

No codes were added in personal.xls or in startup directory?

How to ACtivate a worksheet not a chart sheet?

I am still facing promlem to restroe original Worksheet Menu Bar


Please help

[lucas]

tqm,
I cannot figure out your problem...you say:

I mean the bar that contains (File, Edit, View, Insert,Format,Tools, Date,Window, Help) is not present.

but the picture you posted in your workbook shows that menu? I think we are misunderstanding something...you mentioned:

How to ACtivate a worksheet not a chart sheet?

Which would be on the insert menu, so I'm not sure what your saying is wrong...I attached the picture from your excel file to this post so we could try again to talk about it and figure out what is going on.

[tqm1]

Dear Sir,

In picture, please see Edit Menu
There is not Delete, Find, Replace and Goto etc.

In main menu ther is no DATA
Instead DATA there is CHART located.

I hope this will help to understand my problem

[lucas]

Try this:
right click on any menu bar.....at the bottom of the list choose customize

From the tabs at the top of the dialog box select Options.....

Look at your choices at the top under personalized menus and toolbars.

[tqm1]

Dear I have so from Customize but nothing changed as you can see in picture

[Bob Phillips]

As I said, you have a Chart sheet activated. not a worksheet. Only you know how.

[tqm1]

As I said, you have a Chart sheet activated. not a worksheet. Only you know how.

So please tell me how to activate worksheet instead of chart sheet?

[Bob Phillips]

You tell me how you activated the chart sheet, then it is simple deduction.

[tqm1]

You tell me how you activated the chart sheet, then it is simple deduction.

I have forgotton.

[lucas]

try inserting a new worksheet

[Ivan F Moala]

Going on what Lucas has posted via the image, it would appear that tqm1 has a legit concern, i.e he does have a Worksheet active with Range B5 selected so it cannot be a Chart sheet OR an embedded chart.
The image clearly shows the Chart menu that is shown when a chart is selected even though he does not have one, it is a New Book

I would suggest tqm1 may have a corrupt xlb file.

Close Xl
search for .xlb
rename it to old.xlb
Try opening Excel now.........

[tqm1]

Thanks EVAN

You really guess to my problem

There is no CHART sheet in my new workbook.

I have searched .xlb both search command and manually but failed to findout.

Could you please tell me the path where is it located on your computer?

[lucas]

Mine is located here:
C:\Documents and Settings\Main\Application Data\Microsoft\Excel\

[tqm1]

on that location ther are only one file

excel11

and there is a empty folder called

xlstart

Now what shoul I do?

[lucas]

what is the file extention of the excel11 file?
Is it an excel11.xlb file?

[tqm1]

Yes its extension is xlb
but when I double click it then Microsoft Excel run but no file opens
and menu remains in its previous position.
I mean the origional does not restored.

At this point what should I do?

[lucas]

I don't think Ivan suggested doubleclicking it...I think he said to rename it and then just run excel....here is a quote from his post:

I would suggest tqm1 may have a corrupt xlb file.

Close Xl
search for .xlb
rename it to old.xlb
Try opening Excel now.........
the reason for renaming it is that if you decide you need it back all you have to do is rename it again back to the original file name.....but I think Excel will create a new one once it can't find the one you rename.