Excel script executable by button in workbook once only once, but fails with an error "the button cannot run since the script was unshared. Contact the owner to share it again" when clicked twice.

Question

Created an excel script, and added a button to the excel workbook. This script is owned by and linked to my account. But since the workbook is accessible to my whole organisation, people are able to execute this script by using the button added. While this button execution works once for the user, rerunning it gives an access error(image attached)

Answer 1

Hi

Have you had any luck finding a solution? I have the same issue. I found that users can run the script by going to the automate button on the ribbon and executing it there, but the button won’t work after the second click.

Hey, no luck, still the same - button won’t work after the second click.

Answer 2

Hi

Have you had any luck finding a solution? I have the same issue. I found that users can run the script by going to the automate button on the ribbon and executing it there, but the button won’t work after the second click.

Answer 3

cdffwe