Share via

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.

Anshal Mukesh Lad 5 Reputation points
2024-05-07T08:47:24.0733333+00:00

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)

Screenshot 2024-05-07 at 2.14.05 PM

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,359 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,541 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,583 questions