Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar/Menu Bar
Help!
Both my menu bar and tool bar have disappeared in Excel. The only thing that appears on my screen the spreadsheet and the header bar (ie Microsoft Excel - Book 1). I am not able add/delete rows or colums, or in fact do anything apart from enter letters or numbers into the cells. This is the same on both new workbooks and existing files. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar/Menu Bar
Press ALT+F11 to open the Visual Basic editor. There, press CTRL+G to
display the Immediate window. In that window, type the following and press Enter Application.DisplayFullScreen = False Then enter the following and press Enter Application.CommandBars("Worksheet Menu Bar").Enabled=True Then enter the following and press Enter: Application.CommandBars("Worksheet Menu Bar").Reset This should get your menu bar back. Once you get the menu bar, you can go to the View menu and choose the toolbars you want to display. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Big Dave" wrote in message ... Help! Both my menu bar and tool bar have disappeared in Excel. The only thing that appears on my screen the spreadsheet and the header bar (ie Microsoft Excel - Book 1). I am not able add/delete rows or colums, or in fact do anything apart from enter letters or numbers into the cells. This is the same on both new workbooks and existing files. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar/Menu Bar
I had the same problem as described.
The instructions bellow solved the problem with Menu Bar, but i can't see none standard tool bar. Can you help me? Thanks Rocha "Chip Pearson" escreveu: Press ALT+F11 to open the Visual Basic editor. There, press CTRL+G to display the Immediate window. In that window, type the following and press Enter Application.DisplayFullScreen = False Then enter the following and press Enter Application.CommandBars("Worksheet Menu Bar").Enabled=True Then enter the following and press Enter: Application.CommandBars("Worksheet Menu Bar").Reset This should get your menu bar back. Once you get the menu bar, you can go to the View menu and choose the toolbars you want to display. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Big Dave" wrote in message ... Help! Both my menu bar and tool bar have disappeared in Excel. The only thing that appears on my screen the spreadsheet and the header bar (ie Microsoft Excel - Book 1). I am not able add/delete rows or colums, or in fact do anything apart from enter letters or numbers into the cells. This is the same on both new workbooks and existing files. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to deploy custome toolbar/Menu commands in Excel? | Excel Worksheet Functions |