How to create a Macro Button in Excel?

 How to create a Macro Button in Excel?

How to insert button in Ms Excel?

MACROS IN EXCEL - https://youtu.be/tvw6rPbJHtc

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks.

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.

Follow this link to get worksheet used in the tutorial:

https://drive.google.com/file/d/1JAqx1ADxHbhPcOHNhS1dDiyYXRfkY7a3/view?usp=sharing

# Some important point to remember before creating a Macro-

∆ If you want to save macros, then you must save your workbook in a macro-enabled format *.xlsm

∆ The macro name should not contain any spaces.

∆ Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing.

MACRO BUTTONS

Macros make life easier. Buttons make life easier. 
You can literally run through a hundred steps with just one small click using macros and buttons–which, of course, is both empowering and gratifying.

# Three different types of buttons you can place on a worksheet.

Shapes

Form Control Buttons

ActiveX Control Buttons

In my opinion, the best way to create macro buttons is to use shapes. Shapes give us the most styling/formatting options, and we can make them look like buttons you click every day on modern web pages.