Top menu

  • Thread starter Thread starter Craig L.
  • Start date Start date
C

Craig L.

I recently got a file and now, my top menu functions are only; FILE - WINDOW
- HELP. What happened to the tools and other functions that used to be on the
top menu?
 
Hi,

It sounds like the file contained macros that has disabled them.

Look here

http://www.rondebruin.nl/menuid.htm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Right-click anywhere up in the menu/toolbar area and choose Customize
from the popup menu. There, choose the Toolbars tab. Scroll down to
the end of the list and select "Worksheet Menu Bar". Click the Reset
button. It might be the case that the workbook in question has code
that manipulates the command bars. Press ALT F11 to open the VBA
editor. On the left side of the screen should be the Project window.
Press CTRL R if it is not there. In that window, find your workbook
and expand all the tree view nodes by clicking the "+" signs. Double
click the ThisWorkbook module to open it for editing. In that module,
look for

Private Sub Workbook_Open()
' some code
End Sub

This is the likely place that the menu modification code would be.
Unless there is a good read to keep it, delete it and save the file.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top