my scenario is the following: I’m copying a sheet internally of a Libre Calc (184.108.40.206) document by a macro (Basic). In the (source-) sheet I’ve linked a script to a sheet-event (OnChange). By copying this (source-) sheet the new sheet has no macro defined for the sheet-event.
May there’s a way to solve this problem, but i don’t think so because if i do the copy manually the macro is also missing in the new sheet.
I thought that i could add the macro to the sheet-event via a script/macro, but i don’t find the right commands to do so.
May someone knows a howto?