Forum Discussion
ewolf69
Oct 13, 2022Copper Contributor
How to create clear button without Macros
 I have created a document via desktop that will largely be filled via phone. When I open with a phone it disables the macros, so the clear worksheet button I created won't work.     How can I create ...
mtarler
Oct 13, 2022Silver Contributor
ewolf69 you can use AUTOMATE using Excel online and then open the document using online Excel in both cases:
In theory the AUTOMATE script should or will work in desktop also but last I tried they didn't. That said I was able to link a button for an AUTOMATE script to a macro also and hence it work in both cases for me (online it executed the Script and in desktop is executed the Macro)