How can you change the color of the selected range?
 

How do you change the default colour that excel applies to a selected range
of cells? I do not want to permenantly highlight them (fill them) but I do
want the selected range to be more obvious?

Very odd request?

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.Interior.ColorIndex = 3
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew" wrote in message
...
How do you change the default colour that excel applies to a selected
range
of cells? I do not want to permenantly highlight them (fill them) but I do
want the selected range to be more obvious?

You may want to try Chip Pearson's utility:
http://www.cpearson.com/excel/RowLiner.htm

Be aware that with this (and most macros), you lose the ability to do Edit|Undo.

Andrew wrote:

How do you change the default colour that excel applies to a selected range
of cells? I do not want to permenantly highlight them (fill them) but I do
want the selected range to be more obvious?

--

Dave Peterson