A template with specific commands for spreadsheet commands invisible to final user?

[jdlev]

Hi Guys,

So we perform studies for our clients across a range of topics. I was wondering if there was a way to add features only certain people could ever see.

For instance, if I wanted to include a 'reset all' button...where the template we use would be totally blanked to be used for a new study, but only wanted that button to be visable to me and one of my employees - is there a way to do that?

Thanks!

 

[My Aswer Is This]

Why not try assigning your script to a KeyBoard shortcut command.

When you pressed Ctrl+shift+z for example your script would run.
Very unlikely user would do this.

Other wise we could write into the script a line of code asking for a password. If user did not enter proper password script would not run.

Most users would not know how to search scripts looking for the password.