Re: $$Excel-Macros$$ Re: Hi Experts help needed for stock entry

2010-11-21 Thread Rajesh K R
hi Ashish First of all thaks.I tried your code but the color code index is not working well,after the macro2() running it fails to set color code index property, how can i solve it. Regards Rajesh kainikkara On 11/17/10, OpenExcel.com wrote: > Hi Rajesh, > > I modified your code. You may try thes

$$Excel-Macros$$ Re: Hi Experts help needed for stock entry

2010-11-17 Thread OpenExcel.com
Hi Rajesh, I modified your code. You may try these codes: For Sheet1: Event Macro Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False Columns(3).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 3).Interior.Color = vbYellow Applica