Uploaded August 2022 | Updated September 2026, 1 day ago
🔥 Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Unlock the power of modern Excel automation. This tutorial demonstrates how to replace legacy VBA macros with Office Scripts, allowing you to trigger complex automations using interactive buttons directly on your spreadsheet grid.
📁 Download the file with the code here 👉 pages.xelplus.com/scripts-buttons-file
Unlike traditional macros, these scripts are cloud-resident, meaning they function seamlessly across Excel for the Web, Microsoft Teams, and Excel Desktop without the need for macro-enabled (.xlsm) file formats. You will learn how to build a professional UI that empowers your colleagues to run "bulk" tasks—like workbook-wide formatting—with a single click.
What You Will Master:
- The .xlsx Advantage: Why Office Scripts are the secure, IT-approved alternative to VBA.
- Deployment: Inserting and customizing script buttons for a professional dashboard experience.
- TypeScript Logic: Modifying the getWorksheets collection to loop through and automate every sheet in your workbook.
- Cloud Integration: Managing script storage on OneDrive and SharePoint for organization-wide access.
🕐 Timestamps
00:00 - Introduction to Office Scripts: The Modern VBA Alternative
01:05 - Why .xlsx? Running Macros Without Security Warnings
02:17 - Cloud Prerequisites: SharePoint & OneDrive Setup for Scripts
03:07 - How to Record an Office Script in Excel Web
04:17 - Naming & Saving Scripts to Your Microsoft 365 Account
04:37 - How to Add a Clickable Button to Run Scripts in Excel
05:16 - Customizing Button Shapes, Colors & Visual UI
06:09 - Editing TypeScript: How to Automate All Worksheets at Once
07:13 - Coding the "For...Of" Loop to Bulk Process Data
08:32 - Navigating the Official Microsoft Office Scripts API Docs
09:17 - Running Office Script Buttons in Excel Desktop App
10:22 - Using Excel Automation Buttons in Microsoft Teams
11:05 - Automating Boring Excel Tasks: Final Tips & Resources
In this video, I'll show you how you can record a script to loop through an entire workbook to apply a specific formatting. Then we'll assign the script to a button.
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Introduction to Office Scripts: youtu.be/fny4zUycp_w
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #officescripts
🔥 Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Unlock the power of modern Excel automation. This tutorial demonstrates how to replace legacy VBA macros with Office Scripts, allowing you to trigger complex automations using interactive buttons directly on your spreadsheet grid.
📁 Download the file with the code here 👉 pages.xelplus.com/scripts-buttons-file
Unlike traditional macros, these scripts are cloud-resident, meaning they function seamlessly across Excel for the Web, Microsoft Teams, and Excel Desktop without the need for macro-enabled (.xlsm) file formats. You will learn how to build a professional UI that empowers your colleagues to run "bulk" tasks—like workbook-wide formatting—with a single click.
What You Will Master:
- The .xlsx Advantage: Why Office Scripts are the secure, IT-approved alternative to VBA.
- Deployment: Inserting and customizing script buttons for a professional dashboard experience.
- TypeScript Logic: Modifying the getWorksheets collection to loop through and automate every sheet in your workbook.
- Cloud Integration: Managing script storage on OneDrive and SharePoint for organization-wide access.
🕐 Timestamps
00:00 - Introduction to Office Scripts: The Modern VBA Alternative
01:05 - Why .xlsx? Running Macros Without Security Warnings
02:17 - Cloud Prerequisites: SharePoint & OneDrive Setup for Scripts
03:07 - How to Record an Office Script in Excel Web
04:17 - Naming & Saving Scripts to Your Microsoft 365 Account
04:37 - How to Add a Clickable Button to Run Scripts in Excel
05:16 - Customizing Button Shapes, Colors & Visual UI
06:09 - Editing TypeScript: How to Automate All Worksheets at Once
07:13 - Coding the "For...Of" Loop to Bulk Process Data
08:32 - Navigating the Official Microsoft Office Scripts API Docs
09:17 - Running Office Script Buttons in Excel Desktop App
10:22 - Using Excel Automation Buttons in Microsoft Teams
11:05 - Automating Boring Excel Tasks: Final Tips & Resources
In this video, I'll show you how you can record a script to loop through an entire workbook to apply a specific formatting. Then we'll assign the script to a button.
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Introduction to Office Scripts: youtu.be/fny4zUycp_w
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #officescripts
