This video goes over adding a button to your sheet using Form Controls, and then changing the button's look and feel.
Next, we assign an existing macro for one of the button's event, so that it will run every time we click the button.
Most importantly, I discuss macro security settings and how to prevent using them in untrusted files.
Lastly, I answer a viewer's question about using a button to recalculate random numbers. There's a very small chance that you can get rich using it. 😁
Thanks for watching!

Using Checkboxes in Calc ☑
   • How to Add and Use a Checkbox in Libr...  
Learn to create a macro in Calc ➰
   • Getting Started with Macros (Basic Ex...  

Code for the two macros used:
Sub HelloMacro
Print "Hello"
End Sub

Sub RecalculateSheet
ThisComponent.calculateAll()
End Sub

Video Chapters
0:00 Add a button
1:20 Anchor to cell
2:22 Fit to cell size
2:38 Change label, font and colors
3:36 Link a macro
4:56 Macro security
6:17 Answering viewer question
6:54 Recalculate random numbers


#LibreOfficeCalc