Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. Go to Excel > Preferences…> Ribbon & Toolbar. In the Customize the Ribbon category, in the Main Tabs list, select the Developer check box, and then click Save.. Add a button (Form control) Follow these steps: On the Developer tab, click Button .