I can't edit excel by right clicking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the right click function back(on my mouse)? 5
excel 2007 right click edit query 1
turn on right click menu in excel 2003 1
Closing excel 1
Can't edit worksheet 1
What caused my paste function not to work? 2
Can't Edit Worksheet Comments 1
Edit cell by using mouse - right click 1

Back
Top