How to Grant Access to Apps Script attached to a sheet

[Susan Bowen]

This is a newbie question.  I have a spreadsheet that is shared with 5 users (that have edit access).  I wrote an apps script that populates dropdowns based on what was picked in the column before.  I also have 3 buttons to sort the data in different ways.

So this functionality works fine for me, but is there a way to not have to have each user deal with that ugly Authorization Required popup (well ugly after they get to the 'Google hasn't verified this app').

This is a volunteer job and I just want to get this over with (not looking to become a serious coder).  So is there an easy way to just grant them access, so they have the same functionality?

[CBMServices Web]

Unfortunately, there is no way around each user having to autborize the software.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/800b4015-218f-45ca-80bb-8fd8be280fb2n%40googlegroups.com.

[Susan Bowen]

OK, thanks George.

[Jonathan Butler]

It's possible with a significant amount of work. You would have to set up a web app then have the sheet application call the web app. The web app will have the permissions, and the sheets menu script will simply make a fetch request which doesn't need permissions. 

--