| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I have a cell highlight when selected?
How do I automatically have a cell highlight when it is selected, regardless
to where the location is in the spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
There is a great addin by Chip Person to do excatly what you are looking for...
http://www.cpearson.com/excel/excelM...ightActiveCell -- HTH... Jim Thomlinson "Rhonda" wrote: How do I automatically have a cell highlight when it is selected, regardless to where the location is in the spreadsheet? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Jim,
Thanks for the prompt response, I'm somewhat new at this where do I find and insert the code in the workbook? Do I insert exactly what is written? Rhonda "Jim Thomlinson" wrote: There is a great addin by Chip Person to do excatly what you are looking for... http://www.cpearson.com/excel/excelM...ightActiveCell -- HTH... Jim Thomlinson "Rhonda" wrote: How do I automatically have a cell highlight when it is selected, regardless to where the location is in the spreadsheet? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Hi Rhonda,
Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Typo patrol.........I found one instead of creating one<g
Make that.........Right-click on the worksheet tab and paste the code. Gord Dibben MS Excel MVP On 2 Oct 2006 13:16:12 -0700, "Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Thanks for correcting me ...
How much is the fine charged by the "typo patrol" ... ??? Cheers Carim |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
I had a similar question. Is there a way to keep each cell highlighted once
they are selected versus this code which only highlights the active cell? It's helpful when we have data on an Excel worksheet that we are manually entering into another system to know which cells we have already done. Thanks. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Fortunately..........nothing.
Otherwise I would be destitute and reduced to Alpo once a day. Gord On 2 Oct 2006 13:44:30 -0700, "Carim" wrote: Thanks for correcting me ... How much is the fine charged by the "typo patrol" ... ??? Cheers Carim |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Fantastic, it works! I'm like a child at Christmas, thank you soooo much
Carim! Rhonda "Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
Thanks Gord, I did that after I realized that the left did not give me
options, you guys are great, thanks again! Rhonda "Gord Dibben" wrote: Typo patrol.........I found one instead of creating one<g Make that.........Right-click on the worksheet tab and paste the code. Gord Dibben MS Excel MVP On 2 Oct 2006 13:16:12 -0700, "Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
I have a similar problem/question. My active cell no longer has a 'box'
around it so I know it's active, how do I get that feature back? TIA, Jewelzz "Rhonda" wrote: Fantastic, it works! I'm like a child at Christmas, thank you soooo much Carim! Rhonda "Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
This works but how do I make it global rather than for an individual
worksheet? Previous versions of Office always highlighted the selective active cells, but Office 2007 has it in some kind of barely noticeable off-white color. "Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I have a cell highlight when selected?
"Carim" wrote: Hi Rhonda, Use the following code : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub This code is to be inserted into the worksheet module ... Left click on your worksheet tab Select view Paste the above code... You are all set ... HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change cell text based on another selected cell? | Excel Discussion (Misc queries) | |||
| Comments Appearing When Cell Is Selected (Not Hovered Over) | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
| How to highlight row and column of the selected cell | Excel Discussion (Misc queries) | |||
Linear Mode
