Paste and Paste Special options are disabled

[Abu.Surendran]

Guys

Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help

 

[Shasur]

Here is your code

Sub Enable_Buttons()

Dim oC1 As CommandBar

Set oC1 = Application.CommandBars("CELL")
oC1.Controls("&Paste").Enabled = True
oC1.Controls("Paste &Special...").Enabled = True

End Sub


Just in case you still need to disable here's the link
http://vbadud.blogspot.com/2007/08/disable-cut-copy-from-popup-menu-excel.html