No, I could not make any macros work, but then I'm very new to macros. I wasn't able to find any other answer and gave up. I just protected the form and added instructions on how to unprotect it if new rows are needed - not the best solution!

So please do let me know if you figure something out. Good luck!