Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top menu
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. "Craig L." wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top menu
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 On Sun, 14 Mar 2010 13:20:01 -0700, Craig L. <Craig wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Excel -My paste menu is not the norm. The menu is different. | Setting up and Configuration of Excel | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |