ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control Bar (https://www.excelbanter.com/excel-programming/271693-control-bar.html)

Brandon Waskiewicz

Control Bar
 
I load up excel, and the menu bar with File Edit etc. is
not showing up at the top of the screen. I right click on
the toolbar, go to customize, and check to see if the
Spreadsheet checkbox is checked. It is, but it still
doesn't show up. I uncheck it to see if there is a change-
there isn't. I press Ok after unchecking, and then go
back into customize toolbars, and the box is rechecked
again, even though I didn't check it again. I tried reset
to the defaults on the Spreadsheet control toolbar menu,
but that didn't do anything either. Does anyone have any
ideas on how to fix the toolbar and make it show up on
the screen again?
Thanks
-Brandon

Tom Ogilvy

Control Bar
 
Close excel

Search your drive and look for a file with an *.xlb extension using file
Search in the start menu.

This holds your commandbar customization. Rename it. It should have a
format like username10.xlb


Rename this file to something like username10.oldxlb

then open Excel.

You default commandbar layout should be presented.

Regards,
Tom Ogilvy


"Brandon Waskiewicz" wrote in message
...
I load up excel, and the menu bar with File Edit etc. is
not showing up at the top of the screen. I right click on
the toolbar, go to customize, and check to see if the
Spreadsheet checkbox is checked. It is, but it still
doesn't show up. I uncheck it to see if there is a change-
there isn't. I press Ok after unchecking, and then go
back into customize toolbars, and the box is rechecked
again, even though I didn't check it again. I tried reset
to the defaults on the Spreadsheet control toolbar menu,
but that didn't do anything either. Does anyone have any
ideas on how to fix the toolbar and make it show up on
the screen again?
Thanks
-Brandon




Brandon Waskiewicz

Control Bar
 
Ah! Perfect. Thank you :)


All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com