Say Goodbye to Boring Excel Tasks: Create Cool Buttons to Run Office Scripts from ANYWHERE

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. Not only does this make it easy for others to run the script, but the script is available automatically to anyone you share this workbook with. This way you do not need a macro-enabled workbook to run the automation.

Key Highlights:
- Introduction to Office Scripts: Understand what Office Scripts are and how they can replace traditional macros, offering flexibility and ease of use across various platforms.
- Cross-Platform Compatibility: Learn how you can run scripts not only in Excel on the web but also in Microsoft Teams and even on the desktop version of Excel.
- Interactive Button Creation: Explore how to add visually appealing, clickable buttons to your Excel sheets, making script execution easy and intuitive for anyone.
- Real-World Application: Follow a practical demonstration where we automate the formatting process across multiple worksheets with just a few clicks.
- Editing and Customization: Gain insights into customizing buttons and editing scripts to suit your specific needs, enhancing your Excel experience.
- Script Accessibility: Find out the important requirement of having your files on SharePoint or OneDrive to access and run Office Scripts effectively.
- Hands-On Tutorial: Walk through a step-by-step guide to recording an Office Script from scratch, making your spreadsheets more dynamic and efficient.
- Sharing and Collaboration: Understand how these scripts enhance collaboration, allowing shared access and execution within Teams and across platforms.

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.

00:00 Create a Button to Run an Office Script
00:37 Important Information About Scripts
02:35 Record an Office Script
04:27 Create and Modify the Button
05:39 How to Edit the Office Script
08:30 More Information about Scripts
09:04 Running the Office Script
10:52 Wrap Up

🎬 LINKS to related videos:

🚩Let’s connect on social:

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

[azmibumci]

I've been using scripts for up to 5 years now, and applied them with buttons for almost 3 years now. I use it mostly for doing routine monthly formating and generate financial reports within seconds. I also use them to filter and print (in pdf or paper) those reports without having to literally go to the filter drop down or select the specific printer and number of page I want to print. Buttons and scripts have saved me a couple of days at work and lot's of frustration to be honest.

[donaldvanprooyen]

I consider myself pretty competent with Excel and VBA. I must say you have upped my game considerably... you are a treasure which I just discovered recently

[dcpowered]

Please make more Office Script videos!! This is a fantastic new tool and i really want to learn how to use it in more scenarios!

[melissabrown]

I love you! I have taken your VBA class as well as others and have learned a ton. This is definitely my next task for automating our processes. Thank you!!!!

[juanfox]

4:49 I don't have "Add button" option here. The options I have are: Delete, Rename, Automate a task. I have a 365 business suscription. Do you know why I don't have this option? Is any way to activate it or another way of adding buttons?

[techcorner]

Oh I love this. Now this is gonna help me a lot. Thanks lady

[unusedTV]

Office scripts are essentially just JavaScript with some Office-specific functions, so it's easy to use the scripting elsewhere too. It's a transferable skill.

[batarasiagian]

Many thanks. Productivity-enhancing knowledge, well-presented.

As usual.

[chrism]

Thanks Leila, another great video! I never knew much about scripts.

[stevin]

Thank you for sharing! Have a nice day!

[namphungpiyachai]

I am your big fan, you are an awesome teacher!

[Infographicsproject]

Very interesting. It would be nice to present the Office scenarios as an infographic.

[vesaruusunen]

Great video. Thank you!

Could you create a tutorial how to use message box in office scripts? So that user could define content of variable by answering to a box instead of writing it to specific cell.

[jaznihemaiti]

looking forward to a full length course for office script just the way you did for VBA, I've become quite comfortable and proficient after taking your courses !

[latifaaltaqi]

Love this!! Thank you so very much, Leila!!  One thing, the script I recorded is perfect and runs like a dream. However, I needed to move the newly created (run script) button to another tab. Once I did so, the script runs only on the sheet where the button is located. How do I click the button on one tab and get it to run on, say, "Sheet1" of the workbook?

[chh]

" ... these files are on SharePoint ...".

Very timely ...

But alas, I am a novice 'scripts' student. My scripts look like a kindergarten's first reader, i.e., "... See Spot run. Run. Run. Run ..." ... while Leila's scripts (to me) read like Shakespeare. But with Leila as the teacher, I continue to dream that someday I too will be able to write great lines of prose. She is a terrific instructor ... always patient ... always available … always helpful.

Thank you ... thank you ... thank you .... 😍😍

[joshhorn]

4:49 I don't have "Add button" option here. The options I have are: Delete, Rename, Automate a task. I have a 365 business suscription. Do you know why I don't have this option? Is any way to activate it or another way of adding buttons?


omg the frustration. Cant find it anywhere. Where do you find or add the button Automate?

I'm with

[PlayFoFun]

omg the frustration. Cant find it anywhere. Where do you find or add the button Automate?

[YosYos-nize]

hi
I love it.
I only have one comment.
when changing from a single sheet operation to for loop on all sheets, instead of changing all "SelecteSheet" to "W", I would change to loop variable "W" to SelectedSheet. I also think using a name of a single letter like "w" is not a good practice.
Thanks.

[PJoosen]

Got 2 questions,
Will the scripts still work if you share them outside your organisation?
And is it possible to protect your document that people can use the script but not change them?
Thanks already!