Alt + F11 wil open the VB Editor so you can change the code.

To just get the worksheet menu back..............

ViewImmediate Window copy this into the window and hit Enter key

Application.CommandBars("Worksheet Menu Bar").Enabled = True

BTW.......you should always revert to default when you close the workbook.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
ActiveWindow.Caption = ""
With ActiveWindow
.DisplayGridlines = True
.DisplayHeadings = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
End With
With Application
.CommandBars("Worksheet Menu Bar").Enabled = True
.DisplayFormulaBar = True
.DisplayStatusBar = True
.CommandBars("Standard").Visible = True
.CommandBars("Formatting").Visible = True
End With
End Sub


Gord

On Mon, 7 Jan 2008 14:57:02 -0800, dim wrote:

ARGH!!! That worked...thanks....now its gone whenever I open Excel and I cant
get it back! :-(

Is there a shortcut key to get into VBA code when opening a program so I can
change it back?

....oops! :-o