Blog Post

Excel Blog
1 MIN READ

Announcing buttons for Office Scripts: Run scripts with a workbook button

NancyatMSFT's avatar
NancyatMSFT
Icon for Microsoft rankMicrosoft
Nov 02, 2021

Starting today, you—and your colleagues—can run Office Scripts by pressing a button within a workbook. This highly requested feature introduces a new way to share scripts with colleagues, making it easier for users to find and run your scripts. 

 

Script buttons are now available to all organizations with Microsoft 365 commercial or educational licenses. Follow the steps below to try it out: 

 

  1. From the Automate tab, select a script.  
  2. Go to the More options (…) menu in either the Script Details, All Scripts or Code Editor pane.
  3. Select Add button. 

One of the places you can assign a script to a button is the Script Details page.

 

Read more about script buttons for Office Scripts. 

 

Learn more about Office Scripts 

New to Office Scripts and wondering how to get started? Check out these resources created by our team and community: 

 

Share your feedback 

We'd love to hear your feedback as you try out our feature! Below are a few ways you can connect with our team: 

  • Give us feedback through the Feedback button located in the Help tab. Include the phrase "Office Scripts" to ensure the feedback gets properly routed to our team!
  • Inform our product direction through joining our focus group on GreenRoom. 
  • Ask your scripting questions on StackOverflow using the [office-scripts] tag.   

Happy Scripting! 

Nancy on behalf of the Office Scripts team 

Updated Feb 08, 2022
Version 5.0
Blog
Office Scripts
  • RobertSanz's avatar
    RobertSanz
    Copper Contributor
    Dec 02, 2021

    Great! we really need this feature in out organization. cant wait any longer.

    I hope the button can work as a workaround to be able to run scripts in a Office 365 E1 License (kinda weird a pure on-line feature like OfficeScripts isnt available in a pure on-line office license like the E1).

  • RaulDuque's avatar
    RaulDuque
    Copper Contributor
    Dec 09, 2021

    Today I checked, and the "add button" option is already available in my platform!

  • NancyatMSFT's avatar
    NancyatMSFT
    Icon for Microsoft rankMicrosoft
    Dec 10, 2021

    Benoit_Fournier "If I use VBA, I cannot run in web / if I use script I cannot run in app" - absolutely hear you on this. Our team is currently investigating the expansion of running scripts cross-platform - we recognize that people use a variety of Excel platforms to complete their work, and it's our hope that Office Scripts can be an automation solution that enables users to manage their workflows anytime, anywhere.

     

    Thank you for trying out the button and for your feedback, Benoit!

  • RaulDuque's avatar
    RaulDuque
    Copper Contributor
    Nov 19, 2021

    "... starting today " ... I can't see the button yet, when will it be available?

     

  • NancyatMSFT's avatar
    NancyatMSFT
    Icon for Microsoft rankMicrosoft
    Nov 23, 2021

    RaulDuque Our team's still in the process of rolling this out - this is mostly to ensure there's no quirky behavior or issues we may have missed earlier. Excited for you to try this out though, thanks for asking!

  • RobertSanz's avatar
    RobertSanz
    Copper Contributor
    Dec 09, 2021

    NancyatMSFT    Well, our organization has a a mixture of license types, Engineers and up have the E3/E5's and production computers have the E1 accounts (without office installed) for cost reasons, allot of our files have macros to run on apps and some have Office scripts. but the people in prod are manually inputting data instead of using the scripts and its time consuming. so I was hoping that with the buttons a E1 user could run the script that the E3 user  configured and shared with (in the Automate tab that the E1 user doesnt have).

     

     

  • NancyatMSFT's avatar
    NancyatMSFT
    Icon for Microsoft rankMicrosoft
    Dec 09, 2021

    YESSS the button finally made it to you! RaulDuque please feel welcome to share your feedback while you're trying it out (and this also goes for anyone reading this) - I'm updating the blog post above with the most up-to-date way to reach our team. thank you!