Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
I work with xl and another non related application at the same time ( 2
windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
Set the fill color of the active cell to something bright - like yellow,
before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
Thanks, Gary, that will be a solution, but the cell is different everytime,
I'm sure the color will go with the active cell , but how?, formula, macro? THANKS "Gary''s Student" wrote: Set the fill color of the active cell to something bright - like yellow, before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static OldCell As Range If Application.CutCopyMode = 0 Then If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone OldCell.Borders.LineStyle = xlLineStyleNone End If Set OldCell = Target OldCell.Interior.ColorIndex = 6 OldCell.Borders.LineStyle = xlContinuous Else If OldCell Is Nothing Then Set OldCell = Target Else Set OldCell = Union(OldCell, Target) End If End If End Sub Right-click on the sheet tab and "View Code" Copy/paste the code into that sheet module. Whichever cell you select will be high-lighted in yellow. Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 08:05:01 -0800, Excelfan wrote: Thanks, Gary, that will be a solution, but the cell is different everytime, I'm sure the color will go with the active cell , but how?, formula, macro? THANKS "Gary''s Student" wrote: Set the fill color of the active cell to something bright - like yellow, before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
That is cool stuff. Thanks Gord.
Anything alike for CELL BORDERS ? "Gord Dibben" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static OldCell As Range If Application.CutCopyMode = 0 Then If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone OldCell.Borders.LineStyle = xlLineStyleNone End If Set OldCell = Target OldCell.Interior.ColorIndex = 6 OldCell.Borders.LineStyle = xlContinuous Else If OldCell Is Nothing Then Set OldCell = Target Else Set OldCell = Union(OldCell, Target) End If End If End Sub Right-click on the sheet tab and "View Code" Copy/paste the code into that sheet module. Whichever cell you select will be high-lighted in yellow. Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 08:05:01 -0800, Excelfan wrote: Thanks, Gary, that will be a solution, but the cell is different everytime, I'm sure the color will go with the active cell , but how?, formula, macro? THANKS "Gary''s Student" wrote: Set the fill color of the active cell to something bright - like yellow, before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
Cell borders are included in the code but you won't see them while the cell
is selected so don't know why I added that bit. Probably left over from something else. Delete those two lines and you will see the default dark cell outline. OldCell.Borders.LineStyle = xlLineStyleNone OldCell.Borders.LineStyle = xlContinuous Gord On Sat, 20 Dec 2008 12:38:01 -0800, Excelfan wrote: That is cool stuff. Thanks Gord. Anything alike for CELL BORDERS ? "Gord Dibben" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static OldCell As Range If Application.CutCopyMode = 0 Then If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone OldCell.Borders.LineStyle = xlLineStyleNone End If Set OldCell = Target OldCell.Interior.ColorIndex = 6 OldCell.Borders.LineStyle = xlContinuous Else If OldCell Is Nothing Then Set OldCell = Target Else Set OldCell = Union(OldCell, Target) End If End If End Sub Right-click on the sheet tab and "View Code" Copy/paste the code into that sheet module. Whichever cell you select will be high-lighted in yellow. Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 08:05:01 -0800, Excelfan wrote: Thanks, Gary, that will be a solution, but the cell is different everytime, I'm sure the color will go with the active cell , but how?, formula, macro? THANKS "Gary''s Student" wrote: Set the fill color of the active cell to something bright - like yellow, before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with XL and another not related application
Wonderful! Thanks.
"Gord Dibben" wrote: Cell borders are included in the code but you won't see them while the cell is selected so don't know why I added that bit. Probably left over from something else. Delete those two lines and you will see the default dark cell outline. OldCell.Borders.LineStyle = xlLineStyleNone OldCell.Borders.LineStyle = xlContinuous Gord On Sat, 20 Dec 2008 12:38:01 -0800, Excelfan wrote: That is cool stuff. Thanks Gord. Anything alike for CELL BORDERS ? "Gord Dibben" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static OldCell As Range If Application.CutCopyMode = 0 Then If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone OldCell.Borders.LineStyle = xlLineStyleNone End If Set OldCell = Target OldCell.Interior.ColorIndex = 6 OldCell.Borders.LineStyle = xlContinuous Else If OldCell Is Nothing Then Set OldCell = Target Else Set OldCell = Union(OldCell, Target) End If End If End Sub Right-click on the sheet tab and "View Code" Copy/paste the code into that sheet module. Whichever cell you select will be high-lighted in yellow. Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 08:05:01 -0800, Excelfan wrote: Thanks, Gary, that will be a solution, but the cell is different everytime, I'm sure the color will go with the active cell , but how?, formula, macro? THANKS "Gary''s Student" wrote: Set the fill color of the active cell to something bright - like yellow, before selecting the other app. -- Gary''s Student - gsnu200821 "Excelfan" wrote: I work with xl and another non related application at the same time ( 2 windows) I need to see the last cell I left on xl when changing to the 2nd application and of course what happens is that when I do the swithching , that application becomes 'active' and Xl will be the 'inactive window.' Is there any way in earth, that I could still see the last cell I was working on xl before becoming inactive. THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you add related cells in a sum? | Excel Discussion (Misc queries) | |||
Call Application.Volatile(True) NOT WORKING | Excel Discussion (Misc queries) | |||
Application.Volatile Not Working Timely | Excel Discussion (Misc queries) | |||
macro related | Excel Discussion (Misc queries) | |||
Application.Volatile not working as expected | Excel Discussion (Misc queries) |