Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor
I work for a large organization that does not allow for me to use "add-ins".
I deal with very large spreadsheets and sometimes I can't find the box I was last in. Is there a way to make the border around the current cell darker??? Any help is appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor
I don't know of any way to make the active cell border darker. It's pretty
dark already. Would it help to color the entire cell? The following macro will do that. Note that this macro removes all cell colors before it applies the color to the active cell. You may have some colored cells in your sheet that you wish to retain the color, therefore I wrote the macro to deal only with a specific range of cells. I chose A1:G20. Change this as needed. Also, I chose RED (3) as the color. Change as you wish. This macro MUST be placed in the sheet module of your sheet. To access that module, right-click on the sheet tab, select View Code. Paste this macro into that module. "X" out of the module to return to your sheet. This macro works with only that one sheet. If you want this same feature to work with multiple sheets, a different macro can be used. Come back if you need that or you have any other questions. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Not Intersect(Target, Range("A1:G20")) Is Nothing Then Range("A1:G20").Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 3 End If End Sub "Terry" wrote in message ... I work for a large organization that does not allow for me to use "add-ins". I deal with very large spreadsheets and sometimes I can't find the box I was last in. Is there a way to make the border around the current cell darker??? Any help is appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cursor | Excel Discussion (Misc queries) | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
If Cursor = ?? | Excel Discussion (Misc queries) | |||
why am I getting a 3 d cross cursor instead of a pointer cursor? | Excel Discussion (Misc queries) | |||
Can I change the "white cross" cursor in Excel to another cursor? | Excel Discussion (Misc queries) |