How to Create Cool Buttons to Run Office Scripts (to execute boring tasks for you ANYWHERE)
Excel
Aug 13, 2022 12:00 AM

How to Create Cool Buttons to Run Office Scripts (to execute boring tasks for you ANYWHERE)

by HubSite 365 about Leila Gharani [MVP]

Pro UserExcelWordPowerPointLearning Selection

An Office Script is the new way to automate boring tasks in Excel. You can run these scripts on the web, in Microsoft Teams and even on your desktop. Now you can help your colleagues find and run your Office Scripts by adding a cool button to your workbooks.

An Office Script is the new way to automate boring tasks in Excel. You can run these scripts on the web, in Microsoft Teams and even on your desktop. Now you can help your colleagues find and run your Office Scripts by adding a cool button to your workbooks.

In this Video:

  • Create a Button to Run an Office Script
  • Important Information About Scripts
  • Record an Office Script
  • Create and Modify the Button
  • How to Edit the Office Script
  • More Information about Scripts
  • Running the Office Script
  • Wrap Up

More Information about this Macros and Scripts

Introduction to Office Scripts & How to Tweak Macros

https://www.youtube.com/watch?v=fny4zUycp_w&t=0s

More About Office Scripts in Excel

Office Scripts in Excel let you automate your day-to-day tasks. Inside Excel on the web, you can record your actions with the Action Recorder. This creates a TypeScript language script that can be run again any time.

https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

When to use Office Scripts

Scripts allow you to record and replay your Excel actions on different workbooks and worksheets. If you find yourself doing the same things over and over again, you can turn all that work into an easy-to-run Office Script.
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

Power Automaten and Office Scripts

In this step-by-step tutorial, learn how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script.