Right Click Menu option got disabled

[Shivinder Kaushal]

Dear Chandoo,

Please assist me as i am unable to enable right click menu option in excel 2007. I have faced this issue after receiving macro enabled excel file. Now cut.copy,paste and paste special function is in disabled status.
So kindly help me in resolving this issue.

Regards
Shivy

 

[Luke M]

Have you looked within the code for the macro-enabled workbook? It could be as simple as having some code in there that looks like this:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

 

[Shivinder Kaushal]

Have you looked within the code for the macro-enabled workbook? It could be as simple as having some code in there that looks like this:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

Thanks Luke for addressing my concern.

I have already commented all such codes in VBA sheet but still its not working. Is there any code which i add in new excel and resolve this issue.

 

[Luke M]

Would need to know how the option was disable originally.