can we enable and disable menus when we right click on any cell

  • Thread starter Thread starter priya
  • Start date Start date
You don't really give any details, but you could use an event, like this.
where right clicking on A1 will disable the control, and right-clicking on
any other cell will enable it.

Private Sub Workbook_SheetBeforeRightClick( _
ByVal Sh As Object, _
ByVal Target As Range, _
Cancel As Boolean)
With Application.CommandBars("Bar Name") _
.Controls("Menu Name")
If Target.Address = "$A$1" Then
..Enabled = False
Else
..Enabled = True
End If
End With
End Sub

HTH,
Bernie
MS Excel MVP
 
Back
Top