| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format a New View?
Is there any way to create a custom view that would highlight the entire
column and row with the color of my choice when a single cell is selected? This would sure help my eyes when working on large spreadsheets. I currently use the freeze panes function but would like this addition as well. Any help would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a New View?
Add the following code to the worksheet module of your choice and assign it
to the worksheets SelectionChange event. However, this will slow things down a bit as you move about the worksheet. ------------------------------------------------------------------------------------------------ Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim lngRow As Long Dim intCol As Integer lngRow = Target.Row intCol = Target.Column Application.ScreenUpdating = False ActiveSheet.Cells.Interior.ColorIndex = xlNone Range(Cells(lngRow, 1), Cells(lngRow, 256)). _ Interior.ColorIndex = 3 Range(Cells(1, intCol), Cells(65536, intCol)). _ Interior.ColorIndex = 3 End Sub ------------------------------------------------------------------------------------------------ -- Kevin Backmann "Jayne Mae" wrote: Is there any way to create a custom view that would highlight the entire column and row with the color of my choice when a single cell is selected? This would sure help my eyes when working on large spreadsheets. I currently use the freeze panes function but would like this addition as well. Any help would be greatly appreciated |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a New View?
Download Chip Pearson's RowLiner add-in to gain this functionality.
http://www.cpearson.com/excel/RowLiner.htm Easily customizable for colors and line weights. Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 11:41:03 -0700, Jayne Mae wrote: Is there any way to create a custom view that would highlight the entire column and row with the color of my choice when a single cell is selected? This would sure help my eyes when working on large spreadsheets. I currently use the freeze panes function but would like this addition as well. Any help would be greatly appreciated |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a New View?
But be aware that this event code will wipe out any existing background
formatting you may currently have. Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 14:31:04 -0700, Kevin B wrote: Add the following code to the worksheet module of your choice and assign it to the worksheets SelectionChange event. However, this will slow things down a bit as you move about the worksheet. ------------------------------------------------------------------------------------------------ Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim lngRow As Long Dim intCol As Integer lngRow = Target.Row intCol = Target.Column Application.ScreenUpdating = False ActiveSheet.Cells.Interior.ColorIndex = xlNone Range(Cells(lngRow, 1), Cells(lngRow, 256)). _ Interior.ColorIndex = 3 Range(Cells(1, intCol), Cells(65536, intCol)). _ Interior.ColorIndex = 3 End Sub ------------------------------------------------------------------------------------------------ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a New View?
Thank you Kevin. I appreciate your help
"Kevin B" wrote: Add the following code to the worksheet module of your choice and assign it to the worksheets SelectionChange event. However, this will slow things down a bit as you move about the worksheet. ------------------------------------------------------------------------------------------------ Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim lngRow As Long Dim intCol As Integer lngRow = Target.Row intCol = Target.Column Application.ScreenUpdating = False ActiveSheet.Cells.Interior.ColorIndex = xlNone Range(Cells(lngRow, 1), Cells(lngRow, 256)). _ Interior.ColorIndex = 3 Range(Cells(1, intCol), Cells(65536, intCol)). _ Interior.ColorIndex = 3 End Sub ------------------------------------------------------------------------------------------------ -- Kevin Backmann "Jayne Mae" wrote: Is there any way to create a custom view that would highlight the entire column and row with the color of my choice when a single cell is selected? This would sure help my eyes when working on large spreadsheets. I currently use the freeze panes function but would like this addition as well. Any help would be greatly appreciated |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a New View?
Thank you as well Gord. I appreciate the additional information and link.
"Gord Dibben" wrote: Download Chip Pearson's RowLiner add-in to gain this functionality. http://www.cpearson.com/excel/RowLiner.htm Easily customizable for colors and line weights. Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 11:41:03 -0700, Jayne Mae wrote: Is there any way to create a custom view that would highlight the entire column and row with the color of my choice when a single cell is selected? This would sure help my eyes when working on large spreadsheets. I currently use the freeze panes function but would like this addition as well. Any help would be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set the default comment format and view in Excel | Excel Discussion (Misc queries) | |||
| remove view format | Excel Discussion (Misc queries) | |||
| How can I view a document that is PDF format ? | Excel Discussion (Misc queries) | |||
| external database to view in EXCEL format | Excel Discussion (Misc queries) | |||
| change view format of selected cell | Excel Discussion (Misc queries) | |||
Linear Mode
