Worksheet tab menu (right-click) is missing Delete

[genegal]

Afternoon everyone,

I noticed this problem about a month ago when I was working on an excel file
for my dad for an accounting spreadsheet. When I wanted to make a copy and
delete a previous table, I noticed that I wasn't able to select the delete
function. And it seems that the delete option has disappeared entirely; it
doesn't appear anymore in Excel, regardless of the file (including blank/new
files) or the file format.

I've already tried a repair of Excel, but this hasn't been successful, are
there any other recommendations for this problem?

Thank you for your time in helping me.

Gene

 

[Jan Karel Pieterse]

Hi Genegal,

I've already tried a repair of Excel, but this hasn't been successful, are
there any other recommendations for this problem?

- Open Excel
- Hit alt+F11
- Hit control+g
- enter this line and hit enter:

application.CommandBars("ply").Reset

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[genegal]

Fantastic! It worked like a charm!

Thank you very much Jan!

Gene.

 

[Jan Karel Pieterse]

Hi Genegal,

Fantastic! It worked like a charm!

Great, thanks for letting us know!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com