How to create clear button without Macros

Copper Contributor

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 a clear worksheet button without macros?

 

This will have to be written as to only clear a select volume of cells as to not delete the template which is locked. Also, some of the cells I want to clear contain drop downs via data validation that I want to keep.

1 Reply

@ewolf69 you can use AUTOMATE using Excel online and then open the document using online Excel in both cases:

mtarler_0-1665686219361.png

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)