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 pr...
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 Sub
Add. Infos:
NikolinoDE Thanks for your proposals, but did you test them in Excel online? I cannot see a working solution!
Work with VBA macros in Excel for the web: "Although you can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web,..."
Conditional formatting also does not work, as it needs manual recalculation...
Unfortunately I didn't try it in Online Excel.
Sry it can't work in excel online.
As Mr. Vogelaar mentioned, it is not possible to highlight an active cell except with Office Script. Recommend a subscription version or a desktop version of Excel to be able to use all functions or as mentioned, Office script.
Thank you for your understanding and patience
- Thank you both, unfortunately it has to be Excel online and not desktop app.
Office script could be a workable solution I have to look into.
There is no built-in way to do what you want in Excel Online
Perhaps Office Scripts can do it.
