How to insert a macro button to run macro in Excel? You must have seen it on hundreds of web pages where you are asked to select an option by clicking on a small round shape next to the text. Launch Excel 2010, Create or open a datasheet in which you want to create button for Macros. Click the Advanced tab. Microsoft Excel 2010 or Excel 2013. How to apply a button to clear specific cells in Excel? In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Assign a macro to a Form or a Control button. In Excel 2010 and subsequent versions, click File > Options > Customize Ribbon, select the Developer check box, and click OK. ... After you insert a check box or option button, you might want to make sure that it works the way you want it to. Click the File tab, and then click Excel Options. Click the Microsoft Office Button, and then click Excel Options. VBA macros are the most advanced level of excel and we all know about that as well. A Radio Button in Excel (also called the Option Button) can be used to select one of the many choices/options. Click the Advanced tab. We have included a datasheet, containing fields; Name, Courses, Marks, Grade Prize Money. Click to clear the Show Insert Options buttons check box in the Cut, copy, and paste section, and then click OK. Microsoft Office Excel 2007. In this article, we will write a simple macro and how to assign that macro a button to run at any point in time. Excel Insert Button (Table of Contents) Introduction to Excel Insert Button; How to Insert a Button in Excel? If you are always need to clear these specific cells time to time, you can create a clear button to clear them with just one click. Normally, you can hold the Ctrl key to select multiple specific cells, and then clear the cell contents as you need. For instance, we will be using a very simple example to illustrate it in detail. Introduction to Excel Insert Button. And every time when you apply the macro, you have to press keyboard shortcuts you set for this macro, or click View > Macro > Select the proper macro > Run.Think of easy ways to apply macros? You may load a useful macro with Microsoft Excel VBA. ... On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Button.