Highlighted

[Phil Kirby]

In 2007 anyone know how to make a selected column darker so as to make
found cell using Find & Replace more visable
The shading is so light I can hardly see the highlighted cell

 

[Claus Busch]

Hi Phil,

Am Fri, 26 Apr 2013 08:24:33 +0100 schrieb Phil Kirby:

In 2007 anyone know how to make a selected column darker so as to make a
found cell using Find & Replace more visable
The shading is so light I can hardly see the highlighted cells

try:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myRange As Range

With ActiveSheet
Set myRange = Intersect(Target.EntireColumn, .UsedRange)
.UsedRange.Interior.ColorIndex = xlNone
myRange.Interior.ColorIndex = 15
End With
End Sub

Put the code in the code module of the expected sheet


Regards
Claus Busch

 

[Phil Kirby]

Hi Phil,

Am Fri, 26 Apr 2013 08:24:33 +0100 schrieb Phil Kirby:
-

try:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myRange As Range

With ActiveSheet
Set myRange = Intersect(Target.EntireColumn, .UsedRange)
.UsedRange.Interior.ColorIndex = xlNone
myRange.Interior.ColorIndex = 15
End With
End Sub

Put the code in the code module of the expected sheet


Regards
Claus Busch

Cheers Claus,
Although I appreciate a macro on each woksheet would work but that wil
restrict it
There must be a way to default in the display properties somewhere

Anyone?

 

[Gord Dibben]

Phil

This used to work in Excel 2007........no sure if it still does.

You can add or modify a key in the Registry if you are comforatble
hacking in the Regsitry.

Best to create a Restore Point before attempting any changes.

Start>Run regedit.exe

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

On right-side pane right-click on "Options6" and modify>decimal number
from 32 to 16.

If you don't have an Options6 you must create it by adding a new DWORD
value

Edit>New>DWORD

Rename to Options6 and set decimal value to 16

Selected cells on 2007 will be Black

Gord

 

[Gord Dibben]

Yes, it does still work.

Gord

Phil

This used to work in Excel 2007........no sure if it still does.

You can add or modify a key in the Registry if you are comforatble
hacking in the Regsitry.

Best to create a Restore Point before attempting any changes.

Start>Run regedit.exe

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

On right-side pane right-click on "Options6" and modify>decimal number
from 32 to 16.

If you don't have an Options6 you must create it by adding a new DWORD
value

Edit>New>DWORD

Rename to Options6 and set decimal value to 16

Selected cells on 2007 will be Black

Gord

 

[CellShocked]

Cheers Claus,
Although I appreciate a macro on each woksheet would work but that will
restrict it
There must be a way to default in the display properties somewhere

Anyone??

Give it a range name, and when referenced in/with 'select', it will
always be the expected "highlighted area".

Picking it from the drop down list of named ranges up in the upper left
corner of the worksheet takes you there instantly, fully and properly
highlighted, with absolute and "high" confidence.

 

[CellShocked]

In 2007 anyone know how to make a selected column darker so as to make a
found cell using Find & Replace more visable
The shading is so light I can hardly see the highlighted cells

Once a "find" action has been selected, and there was no "no match
found" message, you can use the cursor key to shift over and back one
cell, thereby exposing the cell in which the find nested itself.