Naked Worksheet

Bugs

Board Regular
Joined
Aug 21, 2002
Messages
100
I seem to have lost all of my tools and options File,Edit Etc
Can you please help
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi Bugs,

What you are missing is called the Worksheet Menu Bar. This particular bar cannot be inadvertently closed, so chances are it is just "misplaced" elsewhere on the screen. It is easy to accidentally move it somewhere else because all the toolbars can be moved from their default positions with a simple click and drag. It is possible you have even dragged the toobar outside of the Excel process window so that it does not appear to be attached to Excel. In addition it is also easy to make it change shape so that the menu items are arranged vertically rather than horizontally, or laid out in matrix form like a table. So check for the toolbar even outside the Excel window, and also check all the boundaries of the Excel process window. Once you find it simply click on it somewhere that does not activate one of its menu items and drag it back to the top left corner of the Excel process window.
 

Bugs

Board Regular
Joined
Aug 21, 2002
Messages
100
damon i ran this macro which i got from this sPublic Sub main()

Dim cmdbar As CommandBar

For Each cmdbar In Application.CommandBars
cmdbar.Enabled = False
Next

With ActiveWindow
.DisplayHeadings = False
.DisplayWorkbookTabs = False
End With

End Sub

ite which gave me the problem will this help
 

Bugs

Board Regular
Joined
Aug 21, 2002
Messages
100

ADVERTISEMENT

thats not so easy when you dont have a menu bar

Thanks anyway
 

Ivan F Moala

MrExcel MVP
Joined
Feb 10, 2002
Messages
4,209
On 2002-08-31 23:25, Bugs wrote:
thats not so easy when you dont have a menu bar

Thanks anyway

Press Alt F11....look for your macro then run it as swampthing has suggested.
As a side Note, when ever you run macros that change your setup ALWAYS have a way out or Restore macro to restore things back.
 

Forum statistics

Threads
1,144,113
Messages
5,722,559
Members
422,447
Latest member
srclife

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top