Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007
I can't tell, easily, what cell I'm in and find myself keying in the wrong
cell. Is there any way to make the active cell more visible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007
Hi,
Two things you might consider: 1. Note that as you move from cell to cell you see the cell address in the Name Box to the left of the Formula Bar and the Column letter and Row number of the active cell are shaded, orange in 2003. 2. You could install the following code: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Static LastCell On Error Resume Next ActiveCell.Interior.ColorIndex = 40 Range(LastCell).Interior.ColorIndex = 0 LastCell = Target.Address End Sub If this is helpful, please click the Yes button. -- Thanks, Shane Devenshire "Gator Girl" wrote: I can't tell, easily, what cell I'm in and find myself keying in the wrong cell. Is there any way to make the active cell more visible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Import an MS Money 2007 file into MS Excel 2007 worksheet | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel |