3 ways to create nice looking Office Scripts Buttons | Excel Off The Grid
HTML-код
- Опубликовано: 5 июл 2024
- ★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Check out the blog post★
exceloffthegrid.com/office-sc...
★ About this video ★
When Office Scripts were released, there were only two ways to execute a script (1) through the script editor or (2) through Power Automate. Users screamed out for a better way. Microsoft delivered a clickable Office Scripts button that could be added to the face of a worksheet. However, the default button style is a bit ugly. So, wouldn't it be great to have buttons that looked nice and provided a modern-looking interface?
That's what we are doing in this video... 3 ways to create nice looking Office Script buttons that users will want to interact with.
0:00 Introduction
0:46 Adding an Office Scripts button
2:41 Formatting the button
5:24 Using a Script to format the button
8:36 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
Thanks a lot, I use your videos a lot for my work!
Happy to hear that! 😀
So awesome! Thank you for creating/posting this video Mark!
You’re welcome 👍
Excellent and useful explanation. As always, adding a lot of value to our daily work. Thank you Mark.
Thanks Ivan. I’m trying to get a bit more into Office Scripts and put them to use in the real world.
Thanks Mark for this , I'm starting to transpose my VBA button to office script
Let me know how that goes. As I think you might find a few gaps still.
I have a question. Can you use a script that makes multiple buttons, instead of having to manually write scripts and open Menu > Add Button for each. Can I create and run scripts to do that?
I wish we could, but that’s not currently possible.
While we can create shapes with a script, there is no way to allocate the script to the shape.
Hi, I have a question. I have Office 365 and can build my scripts there, but unfortunately, I don't have the ability to name shapes or even change their appearance in the online version of Excel. When I try to name a shape like in the video, I get the error message: "This operation is not yet supported in Excel Online." Also, Office Script is not available in my desktop version. Is there a special version of Excel Desktop that I need to use to access these features?
It just depends when your IT department updates the version of Excel installed on your PC.
Just because you can't name a shape in Excel online, it just means they haven't build the interface yet. You can still write a script to name a shape.
DUOS button - default ugly office script button. 😄
Can you save the button as a style instead of using a script?
I don't think it's possible to save a shape style, and if we can I doubt that transfers across workbooks.
I'm happy to be wrong on this, as I must admit that I didn't test that scenario.