Thread: Cell Colour
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ibrahim Awwad[_2_] Ibrahim Awwad[_2_] is offline
external usenet poster
 
Posts: 3
Default Cell Colour

Dear Frank,

Thanks for the link but I thought that there's something easier instead of
add on.

Best Regards

"Frank Kabel" wrote:

Hi
do you need this to happen automaically. That is if you change the active
cell this cell should be highlighted?. If yes see:
http://cpearson.com/excel/RowLiner.htm

"Ibrahim Awwad" wrote:

Dear Frank,

Well you got my question in a correct way as I need to change the color
of active cell. But I tried to put the statement you sent to me in the VB
Editor and I saved it with one of the sheets of the workbook. But nothing has
worked....
The colors aren't changing at all.
.....


"Frank Kabel" wrote:

Hi
activecell.interior.colorindex=3


"Ibrahim Awwad" wrote:

Dear All,

Can any one tell me how to change the colour of selected cell.

BR
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|
|-----------------------------|