Add a Button to Run Macro in LibreOffice Calc
Автор: Office Nifty
Загружено: 2024-08-24
Просмотров: 9574
Would you like help in using Calc?🧑💻
I have some slots this month to personally help my subscribers and viewers: https://cal.com/nifty
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.
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. 😁
Using Checkboxes in Calc ☑
• How to Add and Use a Checkbox in LibreOffi...
Learn to create a macro in Calc ➰
• Getting Started with Macros (Basic Example...
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: