what is the best way to change the color of the
activecell?

Thanks for your help.

Hi
activecell.colorindex = 3

--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.

Activecell.Interior.ColorIndex = 3

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"alldreams" wrote in message
...
what is the best way to change the color of the
activecell?

Thanks for your help.

Hi
make this
Hi
activecell.interior.colorindex = 3


--
Regards
Frank Kabel
Frankfurt, Germany


Frank Kabel wrote:
Hi
activecell.colorindex = 3


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.

I get this error:

Object doesn't support this object or method

Sub color()
ActiveCell.ColorIndex = 3
End Sub

I want the activecell, at all times, to be gray.

Any suggestions?




-----Original Message-----
Hi
activecell.colorindex = 3

--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.

this work. However, the color change remains after I
changed to a different cell. I want to dynamically
change the color of the activecell only

thanks!

-----Original Message-----
Hi
make this
Hi
activecell.interior.colorindex = 3


--
Regards
Frank Kabel
Frankfurt, Germany


Frank Kabel wrote:
Hi
activecell.colorindex = 3


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.

You need VBA for this

Dim prev As Range

Private Sub Worksheet_Activate()
Set prev = ActiveCell
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

ActiveCell.Interior.ColorIndex = 15
prev.Interior.ColorIndex = xlColorIndexNone
Set prev = ActiveCell
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"alldreams" wrote in message
...
I get this error:

Object doesn't support this object or method

Sub color()
ActiveCell.ColorIndex = 3
End Sub

I want the activecell, at all times, to be gray.

Any suggestions?




-----Original Message-----
Hi
activecell.colorindex = 3

--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.

Hi
for this you would need an event procedure. But maybe the following is
what you're looking for:

http://www.cpearson.com/excel/excelM...ightActiveCell
http://www.cpearson.com/excel/RowLiner.htm



--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
this work. However, the color change remains after I
changed to a different cell. I want to dynamically
change the color of the activecell only

thanks!

-----Original Message-----
Hi
make this
Hi
activecell.interior.colorindex = 3


--
Regards
Frank Kabel
Frankfurt, Germany


Frank Kabel wrote:
Hi
activecell.colorindex = 3


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.

It might be worthy to note that an often undesirable side effect of this is
that you will lose the ability to undo edits as many macros cause the undo
history to zero out.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
for this you would need an event procedure. But maybe the following is
what you're looking for:

http://www.cpearson.com/excel/excelM...ightActiveCell
http://www.cpearson.com/excel/RowLiner.htm



--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
this work. However, the color change remains after I
changed to a different cell. I want to dynamically
change the color of the activecell only

thanks!

-----Original Message-----
Hi
make this
Hi
activecell.interior.colorindex = 3


--
Regards
Frank Kabel
Frankfurt, Germany


Frank Kabel wrote:
Hi
activecell.colorindex = 3


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.