right click menu missing in cell

[cmdex]

Hi, Bit of a problem here. I seem to have lost the ability to right click in
any cell(s) and bring up the shortcut menu. It appears from a row or column
or tab, but not in the cells. Instead, when I right click in a selected
range of cells, it deselects the range and selects the cell my curser is on.
I must have selected (or deselected) an option, but I can't seem to find
which one.
Can anyone offer some solutions?
Thanks
Chris

[CyberTaz]

Do you have any Protection features turned ON? Check Tools>Protection and see
if anything starts with 'Unprotect'.

HTH |:>)

"cmdex" wrote:

> Hi, Bit of a problem here. I seem to have lost the ability to right click in
> any cell(s) and bring up the shortcut menu. It appears from a row or column
> or tab, but not in the cells. Instead, when I right click in a selected
> range of cells, it deselects the range and selects the cell my curser is on.
> I must have selected (or deselected) an option, but I can't seem to find
> which one.
> Can anyone offer some solutions?
> Thanks
> Chris

[Bob Phillips]

Try

Application.Commandbars("Cell").Enabled = True

in the VB IDE Immediate window.

--
HTH

Bob Phillips

"cmdex" <cmdex@discussions.microsoft.com> wrote in message
news:E5374EB1-98FC-40DA-8322-BDC3115F34A3@microsoft.com...
> Hi, Bit of a problem here. I seem to have lost the ability to right click
in
> any cell(s) and bring up the shortcut menu. It appears from a row or
column
> or tab, but not in the cells. Instead, when I right click in a selected
> range of cells, it deselects the range and selects the cell my curser is
on.
> I must have selected (or deselected) an option, but I can't seem to find
> which one.
> Can anyone offer some solutions?
> Thanks
> Chris

[cmdex]

Thanks Bob and Cybertaz,
Turns out it was a new addin application setting. We managed to get it
straight.
Chris