Please help!

[alinka]

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.

 

[Richie(UK)]

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]

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!