Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ![]() If you want to make the active cell appear in a special color, use theįollowing code in the Workbook_ SheetSelectionChange event of the This is a limitation imposed by the basic design of Excel and cannot be changed. This add-in has the same issue with undo: The RowLiner add-in (by the same author as the code below) also looks interesting. Source Can the Excel 'cursor' or 'cell outline' color be changed? ![]() So, yes, it is do-able, but you'll lose your undo facility. 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. ![]() You can use the code ("Highlighting The Active Cell") below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |