Hello,
I have volunteered to help a friend and, having not done much VBA
came here for help. I am a programmer...for over 25 years..just no
with VBA, so don't baby me. lol

I would like to use VBA with Excel 2003 to trap the BeforeRightClic
event. In my vision, doing so (rt-click) anywhere in the workbook
will bring up a drop-down list with 3 items in it. I would like t
highlight the current row with one of 3 colors, depending on which lis
item is clicked.

There will be from 1 to n sheets in the workbook so the module shoul
be global but affect only the current row in whatever sheet tha
currently has focus.

Any help or suggestions will be greatly appreciated.

TIA,
Zen

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com