Is it in all excel files or just this one? Do you have macros in the file? If so, there could be a Worksheet_BeforeRightClick or Workbook_SheetBeforeRightClick event that includes a cancel=true line.
try creating a sub to enable/disable events: Public Sub Events_Enable() Application.EnableEvents = True End Sub Public Sub Events_Disable() Application.EnableEvents = False End Sub run the Events_Disable macro and try it again. Paul ----- Original Message ---- > From: sivam <sivamma...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Mon, October 4, 2010 12:54:00 AM > Subject: $$Excel-Macros$$ Right click > > Hi this is very simple question. But still i am getting problem with > this one. Thats why i am posting this query. In my excel sheet right > click button is not working. Right click button is working on the > outside of excel. Only inside it is not working. While accessing > through keyboards it is working. Can you give me any solution for this > one. > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts