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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

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
Back
Top