Naked Worksheet

[Bugs]

I seem to have lost all of my tools and options File,Edit Etc
Can you please help

 

[Damon Ostrander]

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]

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

 

[Swamp Thing]

Can you try running the macro after changing false to true?

 

[Bugs]

thats not so easy when you dont have a menu bar

Thanks anyway

 

[Swamp Thing]

Alt + F11 will open the vba window.

 

[Ivan F Moala]

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.