Sharing Office Scripts in Excel

Share and unshare your script in a workbook

You can use a script's Details page to share the script in a workbook. Your scripts are stored in your OneDrive. When you share one, you create a link to it in the workbook you have open.

To share a script, take the following steps.

1. On the Automate tab, select the script you want to share from the Office Scripts Gallery by selecting View Scripts.

   Note: You can only share your own scripts. You might have access to other scripts that have been shared with you or built-in sample scripts that can't be shared.

   
   
   
   The Code Editor opens and displays the script you selected.

2. Scroll to the Script access section and open it if the section isn't already open.
   
   

3. Select the Add in workbook button to add the script to your workbook with a button.

   Notes: 

   • Shared scripts can be run by any user with write permissions to the workbook. Anything changed by the script is recorded as an edit by the person running the script, not the script's owner.

   • Any updates you make to a shared script are automatically shared with others. The script is updated when you save it. People using your script may need to reopen it if they have an old version open when you make a change.

   • An Office Script can only be shared within your organization. Scripts can't be shared to external users.

4. Select the down arrow to open a menu with the additional options Add without button and Remove from workbook.
   
   

5. Select Add without button to add the script to your workbook without adding a button to the workbook. To view scripts added to a workbook without a button, see the Code Editor > This workbook list.

6. Select Remove from workbook to remove the script from your workbook.

   Note: Deleting a script button from the workbook won't remove that script from the Code Editor > This workbook list. Use Remove from workbook to remove a script from the workbook.

   Important: Be sure you want to stop sharing, because this can't be undone. To reshare the script, you'll have to manually share it in each workbook again. When you are ready, select Stop Sharing.

Save Office Scripts on a SharePoint site

Save Office Scripts on SharePoint to share them with your team. When you save a script to SharePoint, anyone with access to the SharePoint can view, edit, or run the script.

Allow a shared script to run

The first time you run a script that you don't own, the Run Permission dialog box opens. This asks whether to allow the script to view and edit the workbook. If you trust the author of the script, select Allow.

Requirements

An active Microsoft 365 subscription account with a commercial or educational Microsoft 365 license that has access to the Microsoft 365 Office desktop apps. This includes:

• Microsoft 365 Apps for business

• Microsoft 365 Business Standard

• Microsoft 365 Apps for enterprise

• Office 365 ProPlus for Devices

• Office 365 A3

• Office 365 A5

• Office 365 Enterprise E1

• Office 365 Enterprise E3

• Office 365 Enterprise E5

• Office 365 F3

• Server authentication - When first running the Script Recorder or Code Editor, you need to authenticate with the server, so your scripts can be saved to the cloud. Sign-in to your Microsoft account as usual, then when you see the Permissions requested prompt, choose Accept to continue.

See Also

Introduction to Office Scripts in Excel

Office Scripts settings in Microsoft 365

Create a button to run an Office Script