Use the BeforeRightClick event.

See Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm

Right click on the sheet tab and select view code. Paste in code like:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
SendKeys "{F2}="
Cancel = True
End Sub

--
Regards,
Tom Ogilvy


"Farah" wrote in
message ...

Dear Guru's,

I want to have a code with which If I right click on any cell of the
workbook, on that cell where I Right Clicked it should type '=' in the
Edit Mode.

Is that possible ?


--
Farah
------------------------------------------------------------------------
Farah's Profile:
http://www.excelforum.com/member.php...o&userid=27779
View this thread: http://www.excelforum.com/showthread...hreadid=472922