Macros Apps script on Sheets

[T Apg]

Hello,For the past 2 years, I've created a Sheet with macros coded in Apps Scripts, and I was able to share them without any issues with other users. Since this week, other users can no longer activate the scripts (via a click on an image) - they get a "Small problem: Function xxx cannot be found" error, even though the Apps Script code is properly shared...Do you know how to fix this problem and share the macros with all Editor users of the spreadsheet?I didn't have this problem last month.
Thank you for your help.

[Keith Andersen]

This happened to me the other day. It cleared up on its own. I would suggest clearing all cookies and history from your browser also.

Cheers
Keith

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

On Tue, Aug 6, 2024, 6:08 AM T Apg <theo.a...@gmail.com> wrote:

Hello,For the past 2 years, I've created a Sheet with macros coded in Apps Scripts, and I was able to share them without any issues with other users. Since this week, other users can no longer activate the scripts (via a click on an image) - they get a "Small problem: Function xxx cannot be found" error, even though the Apps Script code is properly shared...Do you know how to fix this problem and share the macros with all Editor users of the spreadsheet?I didn't have this problem last month.
Thank you for your help.

--
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/dc6a52cb-d04b-496d-a2fa-0a641a7c7859n%40googlegroups.com.

[Will Soares]

If it's a bound script, you should be able to share the sheet and the code will inherit the same authorization. Unbound (connected as a library) I had to share the script with them as editor.

Thank You, 
Will Soares

Day to Data Inc.
Mobile: +1908-337-3775
Click Here to Open a Ticket
wi...@daytodata.net
www.daytodata.net 

Book a Session: 30 Minutes

 

CONFIDENTIALITY NOTICE

This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient.  If you have received this transmission in error, please immediately notify the sender and delete it from your system.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BEDEOyEatEPgLk-eYj4d6zrxCQQf3YAjAVam9gBiAoZHg%40mail.gmail.com.

[T Apg]

Yes the script is bound and I didn't have this problem during 2 years... But since the last week, Editors cannot activate macro via a click on an image. How can they use macro again ? Was there an update on Apps Scripts ?

[T Apg]

I also tried that but it doesn't work :(

Cheers,

Théo

[Keith Andersen]

Do you know how to create a custom menu?? Because you could create a custom menu that they could run any of the functions that are attached to buttons from.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7e1cba5b-1512-4dbe-b5c3-3a329da79fbcn%40googlegroups.com.

[T Apg]

Thank you for this idea, 

yes I know how to do it but in my case it is really not optimal: I have images in certain places in the sheets which represent buttons to automatically activate the functions. Everything was fine until last week. Now the Sheets and Apps Script code are shared with another Editor, but it cannot use the buttons...

Thank you for your help,

Cheers,

Théo

[Keith Andersen]

Change the name of one function. The button for this function change it to the new name. Then run a function from a button and it should work.

However, when you close and then reopen it, it may trigger it to go back to the way it was saying that the function can't be found. Change the name of the function back to the original and then change the name of the function in the button back to the original and try it again.

I did this a couple of times and then the problem resolved itself.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/58cb7df9-4161-4d61-b77e-077fd997c0cen%40googlegroups.com.

[milosz tomaszewski]

https://ws.bluemail.info/ws/zWVMtCIoDP

Pobierz aplikację BlueMail dla systemu Android