Solved: Delete Sheet gone from tabs right click menu...

[jaminben]

Hello,

For some reason my delete sheet command has disappeared from my tabs right click menu. All the other commands are still available and I can disable/enable those just fine with:

Application.CommandBars("Ply").Controls("&Rename").Enabled = False

but

Application.CommandBars("Ply").Controls("&Delete").Enabled = True

doesn't seem to bring the delete back.

The workbook isn't protected etc.

Anyone got any ideas?

Thanks

Ben

Edit

I Should've also said its for version 2007 and its affecting any file I open.... no way to delete a sheet :(

[frank_m]

Assuming you don't mind having all of the sheet tab right click commands restored,

Try this
Application.CommandBars("Ply").Reset
Edit: or delete sheets from the ribbon

Home tab > Cells group, click arrow next to Delete, then click Delete Sheet

[jaminben]

Assuming you don't mind having all of the sheet tab right click commands restored.


That did the trick.

Thankyou

:)