Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,853 questions
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 76%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Anshal Mukesh Lad
10
Reputation points
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)
Office
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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.
4,173 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST 13,835 Reputation points Microsoft Vendor2024-05-08T08:47:26.6766667+00:00 Did you encounter an Office update before this issue occurred?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Animesh Prasad 5 Reputation points2024-05-21T05:02:26.0366667+00:00 Hi Jiajing,
This occurs in both our web app and the stand-alone app. Is it safe to assume Web App is always the latest?
-
Anshal Mukesh Lad 10 Reputation points
2024-05-21T14:37:25.8866667+00:00 @Jiajing Hua-MFST
Office would be latest with all updates, but same happening for excel web app is the issue -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hans Douma 5 Reputation points2024-06-16T13:34:00.5666667+00:00 Same issue here. Excel sheet with buttons run fine for me, both locally with Excel (Mac), as well as online via Office365. Once someone else runs the scripts through buttons, the first time it works and then just stops, throwing the message the script was unshared. After clicking around in the sheet, it starts working again (once at least). Other users can run the scripts manually through the Automate window.
This is rather annoying, as we rely a lot on makros for planning purposes.
HD
Sign in to comment
Sign in to answer