Starting today, you and your colleagues can run Office Scripts in Excel for Windows through pressing a button within the workbook. This highly requested feature expands on our recently introduced script buttons feature, meaning you can run the same button in both your browser and Windows application.
Your feedback helped us make the decision to bring script buttons to Windows: since releasing Office Scripts we have heard your desire for a way to share scripts with colleagues, as well as an ability to use scripts in Excel’s desktop application. We’re grateful for your suggestions, thoughts and comments so far and look forward to hearing from you as you try out this feature!
With script buttons in Windows, we move one step closer towards making Office Scripts an automation solution you can use to manage your workflow anytime and anywhere. While you still need to use Excel on the web to create and manage your scripts, we recognize that Excel users use a variety of platforms to complete their tasks and intend to investigate more cross-platform investments as part of our future work.
How it works
To create a button in your workbook:
- From the Automate tab in Excel on the web, select a script.
- Note: Don't have a script in your workbook? Check out this clock in/clock out sample from one of our fellow community members: https://docs.microsoft.com/en-us/office/dev/scripts/resources/scenarios/punch-clock.
- Go to the More options (…) menu in either the Script Details, All Scripts, or Code Editor pane.
- Select Add button.
To run the button in Windows:
- Open a file containing the button in Excel on Windows.
- Select the button in the workbook.
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:
- Office Scripts Homepage
- Introduction to Office Scripts by Leila Gharani
- Office Scripts samples
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.
Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".
Happy Scripting!
Nancy on behalf of the Office Scripts team
Microsoft
