VBA doubleclick doesn't work on web

[Szafranski]

Hi.

I use this vba code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Updateby Extendoffice 20160725
ActiveSheet.Protect Password:="CODE", UserInterfaceOnly:=True
Cancel = True
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy Target.Offset(1).EntireRow
On Error Resume Next
Target.Offset(1).EntireRow.SpecialCells(xlConstants).ClearContents
End Sub

But when my colleagues try to add an extra row in the web/browser version, nothing happens, it works fine in the desktop version.

What is wrong and what can i do, to make it work

 

[Fluff]

Hi & welcome to MrExcel.
I'm afraid that macros do not work in the online version of Excel.

 

[Szafranski]

Ohh
Is there an alternative to autofill the rows. I dosen´t want to use tabels.

 

[Fluff]

Only by doing it manually I'm afraid.
That said, there is something called Office.js which is a java based language that works with the web, but I know nothing about it.