 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / August 2005How do I retrieve my menu bar for an excel worksheet
Hi I have just opened an excel document of mine and there is no menu bar so I can't use it. When this happens at work using our large packages, I open another one and shut it down again using the approved route. With my home document, there is no such path! I'd be very grateful for any help as there is a lot of work at stake here! Many thanks, Linda B Hi Linda, > I have just opened an excel document of mine and there is no menu bar so > I can't use it. Press Alt-F11, then control-g and type this single line, followed by enter: Application.Commandbars("Worksheet Menu Bar").Enabled=True That should give you back your menu. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Hi Jan I followed your instructions and pasted your line into the 'immediate' section but nothing changed. :0( Many thanks for trying though. Linda > Hi Linda, > [quoted text clipped - 12 lines] > Excel MVP > http://www.jkp-ads.com Hi Linda, > I followed your instructions and pasted your line into the 'immediate' > section but nothing changed. Did you press enter whilst having your cursor inside that line? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Hi Jan I've done it again and the cursor is on a new line before I enter return. The icons below the would-be worded menu bar are there now, but not the latter. The 'Word' menu bar shows on the visual basic page too! Sorry to be a pest. Linda > Hi Linda, > [quoted text clipped - 8 lines] > Excel MVP > http://www.jkp-ads.com Hi Linda, > I've done it again and the cursor is on a new line before I enter return. Just position it on the line (anywhere), e.g. by clicking on it and hit enter. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.