Unable to Delete Sheets or see Properties

[Revolvr]

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

 

[Revolvr]

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

 

[Barb Reinhardt]

You may want to let them know to add something to their code to turn things
back on. I've had common shortcuts really messed up (things like CTRL A, or
CTRL P) with programmed keys for macros.

Barb Reinhardt

 

[Revolvr]

You may want to let them know to add something to their code to turn things
back on.   I've had common shortcuts really messed up (things like CTRLA, or
CTRL P) with programmed keys for macros.  

Barb Reinhardt

Turns out they did, when the spreadsheet closed normally, it had
enable logic. Problem is if the workbook doesn't close normally. In my
case it crashed. I think as a design practice there must be a better
way to handle it that would not have a possibility of leaving Excel
changed.