I do not think Macros are capable of doing this. I think it is time for you to move away from Macros
Here is how you create a VBA. Click on the Form Design, then find the Form Current Event in the Event Tab. When you click the three dots (...), it will pop up with the option Choose Builder. The options are "Macro Builder", "Expression Builder", "Code Builder".
Select Code Builder and click OK. You will be taken to the VBA window, just use Me. and follow the name of the button then .Visible = Me.NewRecord. Simples.