Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make the cursor appear as a coloured outline box?
I have been sent a spreadsheet in which the cusor appears as a green outline
box around the cell. how is this done as i can't find any reference in Help etc? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make the cursor appear as a coloured outline box?
Mike
Perhaps some worksheet code like the following? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Static OldCell As Range If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone End If Target.Interior.ColorIndex = 6 Set OldCell = Target End Sub Right-click on the sheet tab and "View Code". See if any code in that module. OR could be some code in the ThisWorkbook Module. Gord Dibben Excel MVP On Wed, 16 Nov 2005 07:29:14 -0800, "MikeB" wrote: I have been sent a spreadsheet in which the cusor appears as a green outline box around the cell. how is this done as i can't find any reference in Help etc? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make the cursor appear as a coloured outline box?
Have you looked at the VBA in the workbook?
-- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "MikeB" wrote: I have been sent a spreadsheet in which the cusor appears as a green outline box around the cell. how is this done as i can't find any reference in Help etc? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
How to make this plot? | Charts and Charting in Excel |