I can't edit excel by right clicking

[Jennie4]

I can no longer use my right click to edit. ie. copy, paste, insert, delete.
It's greyed out. I can still use the edit functions on the tool bar. How do I
get it back to my mouse?

[David McRitchie]

Hi Jenn,
Typically in an Event macro specifically a Change Event macro
you have to disable Events so that a change that you make will not trigger
another Change Event. If you fail to reenable Events or the macro terminates
abnormally and does not reenable Events -- you will not be able to ruen an
event macro or use your right click to do bring up a context menu.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'should be part of Change macro near beginning
Application.EnableEvents = True 'should be part of Change macro near end

Sub Fix_Things()
Application.DisplayAlerts = True
Application.EnableEvents = True 'should be part of Change macro
End Sub

Read more and view a better macro on a link from this link
Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm#problems

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jennie4" <Jen...@discussions.microsoft.com> wrote in message news:C8979C4A-416A-4B25...@microsoft.com...