Easy Ways To View Macros In Excel 5 Steps With Pictures

Windows: Click the File menu and select Options. Click Customize Ribbon. Select Main Tabs from the “Customize the ribbon” drop-down menu. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Check the box next to Developer and click OK. macOS: Click the Excel menu and select Preferences. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Select Main Tabs under “Customize the Ribbon. " Check the box next to Developer. Click Save.

Click the File menu and select Options. Click Customize Ribbon. Select Main Tabs from the “Customize the ribbon” drop-down menu. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Check the box next to Developer and click OK.

Click the Excel menu and select Preferences. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Select Main Tabs under “Customize the Ribbon. " Check the box next to Developer. Click Save.

To see macros in a particular workbook only, select that workbook’s name from the “Macros in” menu.