Change the color of the cursor in Excel











up vote
2
down vote

favorite












I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.










share|improve this question
















bumped to the homepage by Community 2 days ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 2




    Which operating system? Which version of Excel?
    – DavidPostill
    Feb 22 '16 at 18:26










  • Using Excel 2013 with Windows 7
    – Ray
    Feb 23 '16 at 14:34















up vote
2
down vote

favorite












I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.










share|improve this question
















bumped to the homepage by Community 2 days ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 2




    Which operating system? Which version of Excel?
    – DavidPostill
    Feb 22 '16 at 18:26










  • Using Excel 2013 with Windows 7
    – Ray
    Feb 23 '16 at 14:34













up vote
2
down vote

favorite









up vote
2
down vote

favorite











I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.










share|improve this question















I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.







windows-7 microsoft-excel-2013 cursor






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Feb 25 '16 at 15:41









Burgi

3,83992442




3,83992442










asked Feb 22 '16 at 18:19









Ray

1112




1112





bumped to the homepage by Community 2 days ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 2 days ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.










  • 2




    Which operating system? Which version of Excel?
    – DavidPostill
    Feb 22 '16 at 18:26










  • Using Excel 2013 with Windows 7
    – Ray
    Feb 23 '16 at 14:34














  • 2




    Which operating system? Which version of Excel?
    – DavidPostill
    Feb 22 '16 at 18:26










  • Using Excel 2013 with Windows 7
    – Ray
    Feb 23 '16 at 14:34








2




2




Which operating system? Which version of Excel?
– DavidPostill
Feb 22 '16 at 18:26




Which operating system? Which version of Excel?
– DavidPostill
Feb 22 '16 at 18:26












Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34




Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34










1 Answer
1






active

oldest

votes

















up vote
0
down vote













I need to change the cursor color



You can use the code ("Highlighting The Active Cell") below.



However, there is a downside:




There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.




Source Can the Excel 'cursor' or 'cell outline' color be changed?



The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:




RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.






Highlighting The Active Cell




If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange event of the
workbook.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub


This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.



NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.




Source Highlighting The Active Cell






share|improve this answer























  • At the bottom of the page for RowLiner the author states that it also disables Undo.
    – Kyle
    Feb 25 '16 at 21:07










  • @Kyle Well spotted. Thanks. Answer updated.
    – DavidPostill
    Feb 25 '16 at 21:08











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1044108%2fchange-the-color-of-the-cursor-in-excel%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
0
down vote













I need to change the cursor color



You can use the code ("Highlighting The Active Cell") below.



However, there is a downside:




There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.




Source Can the Excel 'cursor' or 'cell outline' color be changed?



The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:




RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.






Highlighting The Active Cell




If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange event of the
workbook.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub


This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.



NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.




Source Highlighting The Active Cell






share|improve this answer























  • At the bottom of the page for RowLiner the author states that it also disables Undo.
    – Kyle
    Feb 25 '16 at 21:07










  • @Kyle Well spotted. Thanks. Answer updated.
    – DavidPostill
    Feb 25 '16 at 21:08















up vote
0
down vote













I need to change the cursor color



You can use the code ("Highlighting The Active Cell") below.



However, there is a downside:




There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.




Source Can the Excel 'cursor' or 'cell outline' color be changed?



The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:




RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.






Highlighting The Active Cell




If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange event of the
workbook.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub


This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.



NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.




Source Highlighting The Active Cell






share|improve this answer























  • At the bottom of the page for RowLiner the author states that it also disables Undo.
    – Kyle
    Feb 25 '16 at 21:07










  • @Kyle Well spotted. Thanks. Answer updated.
    – DavidPostill
    Feb 25 '16 at 21:08













up vote
0
down vote










up vote
0
down vote









I need to change the cursor color



You can use the code ("Highlighting The Active Cell") below.



However, there is a downside:




There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.




Source Can the Excel 'cursor' or 'cell outline' color be changed?



The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:




RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.






Highlighting The Active Cell




If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange event of the
workbook.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub


This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.



NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.




Source Highlighting The Active Cell






share|improve this answer














I need to change the cursor color



You can use the code ("Highlighting The Active Cell") below.



However, there is a downside:




There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.




Source Can the Excel 'cursor' or 'cell outline' color be changed?



The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:




RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.






Highlighting The Active Cell




If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange event of the
workbook.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub


This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.



NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.




Source Highlighting The Active Cell







share|improve this answer














share|improve this answer



share|improve this answer








edited Feb 25 '16 at 21:09

























answered Feb 23 '16 at 14:54









DavidPostill

102k25216252




102k25216252












  • At the bottom of the page for RowLiner the author states that it also disables Undo.
    – Kyle
    Feb 25 '16 at 21:07










  • @Kyle Well spotted. Thanks. Answer updated.
    – DavidPostill
    Feb 25 '16 at 21:08


















  • At the bottom of the page for RowLiner the author states that it also disables Undo.
    – Kyle
    Feb 25 '16 at 21:07










  • @Kyle Well spotted. Thanks. Answer updated.
    – DavidPostill
    Feb 25 '16 at 21:08
















At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07




At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07












@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill
Feb 25 '16 at 21:08




@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill
Feb 25 '16 at 21:08


















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1044108%2fchange-the-color-of-the-cursor-in-excel%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror

Mangá

Eduardo VII do Reino Unido