very helpful.. thanks! is it possible to kick the macro off automatically when the sheet is opened without going to the top menu - EXTENSIONS >MACROS or using keyboard shortcuts ? I'm looking for a workaround when using the SHEETS app on my phone.
To reuse your macro, we suggest create a blank file where you have the macro and everything set up the way you want. Call it "Template" for example. When you need a new file, make a copy of Template, instead of creating a new totally blank file!
very helpful.. thanks! is it possible to kick the macro off automatically when the sheet is opened without going to the top menu - EXTENSIONS >MACROS or using keyboard shortcuts ? I'm looking for a workaround when using the SHEETS app on my phone.
Thank you, it's very helpful!
Glad to hear that!
This content is awesome very awesome .....thanks
Thanks for including the gotchas! Not that I'll remember the solution, but I will know there's a reason!
So glad it was helpful!
Can you save the macros and apply them in new google sheets that you open up?
To reuse your macro, we suggest create a blank file where you have the macro and everything set up the way you want. Call it "Template" for example.
When you need a new file, make a copy of Template, instead of creating a new totally blank file!
@@coefficientio Great idea! Thanks.
Thanks for the information.
I followed the directions in the video and ran the Macro I saved, but nothing happened. Why?
🎉