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? |
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? |
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? |
All times are GMT +1. The time now is 02:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com