Use this macro to highlight the active cell on an Excel worksheet. Temporary lines will appear on the sheet, above and to the left of the active cell.
To make it easier to see the active cell, you can add a macro to your Personal Workbook, following the steps below. This will add line shapes above, and to the left of the active cell.
Because the Personal Workbook opens automatically when Excel opens, this macro will run in any workbook that you open while working in Excel.
NOTE: If you don't want this feature to always be on, you can store the code in a different workbook. Then, open that workbook when you want the feature available.
You might have seen other macros that highlight the active cell, and they often change the fill colour of the active cell. If your worksheet has cells with fill colour already, those macros will override that formatting.
With this method, by Phil Treacy from My Online Training Hub, the cell formatting is not changed.
However, there is one important warning -- using macros like this one will prevent you from using the Undo feature in Excel
If you don’t have a Personal Workbook, follow these steps to set one up:
Next, follow these steps, to find the module where you’ll add the macro code:
Next, follow these steps to find and copy the code that you'll paste into that code module:
Follow these steps to get the macro code into your Personal Workbook:
To start using the macro, follow these steps:
Or, if you added the code to a different workbook (not the Personal Workbook), open the file with your code.
Remember -- using this macro will prevent you from using the Undo feature.
Last updated: December 16, 2019 2:09 PM
Contextures RSS Feed