I found the problem. Last Friday I had opened someone elses Excel
workbook that had this code in it. The code apparently disables some
menu options, and those remain disabled even if Excel is closed and
restarted. I was able to re-enable the menu items by inverting the
logic and running the macro. Wow how annoying.

'Option Explicit
'Private Sub workbook_activate()
'Dim Con As CommandBarControl, conb As CommandBarControl

' For Each Con In Application.CommandBars.FindControls(ID:=847)
' Con.Enabled = False
' Next
' For Each conb In Application.CommandBars.FindControls(ID:=750)
' conb.Enabled = False
' Next
'End Sub



On Oct 12, 12:43*pm, Revolvr wrote:
OK so this is weird. I am unable to delete a worksheet. The workbook
is not protected nor is it shared, and there is no VBA code. In fact
if I just open Excel and get the default 3 sheet blank workbook, I
have the same problem. Delete sheets is grayed out.

Also I cannot see the Properties under the file menu. It is grayed out
too.

This just suddenly happened today, with any spreadsheet. What I can do
is "Move or copy sheet" and move a sheet to another workbook, then
delete that workbook.

Anyone have any clues, or even ideas how to debug this?

Thanks

-- Rev