Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hope Someone Can Help...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hope someone can help me | Excel Discussion (Misc queries) | |||
Hope someone here can help me | Excel Discussion (Misc queries) | |||
Last Hope -HELP!! | Excel Programming | |||
Last Hope -HELP!! | Excel Programming | |||
I hope I ask this correctly | Excel Programming |