Alt + F11 to open VBE

ViewImmediate Window

Paste in Application.CommandBars("Ply").Enabled = True

then hit Enter

The "all of sudden" part prolly came from some code you ran.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 11:09:01 -0800, blanch2009
wrote:

All of a sudden I have no right click on my sheet tabs. The sheet or even
the workbook is not protected in any way.
Normally you can right click on a sheet tab and either delete, rename, copy,
ect.
Now nothing. The tab is not grayed out and if you double click it you can
rename but that's it.
Does anyone know how to fix this problem?

Thanks In Advance