Please help!

alinka

Board Regular
Joined
Oct 30, 2002
Messages
70
Hi,

When I open Excel, I am missing the Format and Tools drop down menu in all my workgroups and sheets. I cannot fix it no matter what I tried. Can someone tell me what happened and how i can fix and prevent this from happening again?

I also just noticed that I cannot even right click on my sheets - the right click menu is gone. What is happening to my excel?

Thanks so very much for any help.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi alinka,

Have you been experimenting with macros and commandbars? If you have, make sure that whatever routine you used has now been removed.

Have you recently opened a workbook from somebody else that contained macros? Could this have customised the menus?

Anyway, see if this routine helps?
<pre>Sub ComeBack()

Application.CommandBars("Cell").Reset
'restore the right click mouse button menu

With Application.CommandBars("Worksheet Menu Bar")
'restore Tools and Format menu items
.Controls("Tools").Enabled = True
.Controls("Tools").Visible = True
.Controls("Format").Enabled = True
.Controls("Format").Visible = True
End With

End Sub</pre>
HTH
 

alinka

Board Regular
Joined
Oct 30, 2002
Messages
70
Richie,

Thanks for your reply. I really appreciate this. I am new to Excel routines and such. Could you please indicate where exactly I should place the code of this routine? Thanks so much again!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,535
Messages
5,602,217
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top