Forum Discussion
Highlight active row/column in Excel
Hello,
for the Excel desktop app there are different ways to highlight an active row/column.
In Excel Online I sometimes really struggle to see the active cell, especially in meetings when presented by projector.
Is there any way to get these settings changed in Excel Online?
Thanks
NikolinoDE Thanks, but the solutions do not apply to Excel Online...
Another try...my link :))
Highlight active row and column without VBA
Actually, the VBA code should also work, but it has to be integrated into the workbook in advance from a subscription or desktop version, since you cannot create VBA code with online Excel.
However, you can open and edit the macro-enabled workbook in Excel for web.
Work with VBA macros in Excel for the web
Example VBA code input: Press ALT + F11 key combination to open VBA.
Then select ThisWorkbook in the left project explorer,
double click it to open the module,
and copy and paste the following VBA code into the blank module:
Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Static xLastRng As Range On Error Resume Next Target.Interior.ColorIndex = 6 xLastRng.Interior.ColorIndex = xlColorIndexNone Set xLastRng = Target End SubAdd. Infos:
