right click menu missing in cell

C

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
 
C

CyberTaz

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

HTH |:>)
 
B

Bob Phillips

Try

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

in the VB IDE Immediate window.
 
C

cmdex

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