Make the visual basic editor in excel for mac look like pc?

broken image

Next, in the Customize the Ribbon section, under Main Tabs, check the Developer check box.

broken image

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it.įor Windows, go to File > Options > Customize Ribbon.įor Mac, go to Excel > Preferences. If a workbook contains a Visual Basic for Applications ( VBA) macro that you would like to use elsewhere, you can copy the module that contains that macro to another open workbook by using the Visual Basic Editor ( VBE). Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 More.

 

PreviousNext
Cookie Use
We use cookies to improve browsing experience, security, and data collection. By accepting, you agree to the use of cookies for advertising and analytics. You can change your cookie settings at any time. Learn More
Accept all
Settings
Decline All
Cookie Settings
Necessary Cookies
These cookies enable core functionality such as security, network management, and accessibility. These cookies can’t be switched off.
Analytics Cookies
These cookies help us better understand how visitors interact with our website and help us discover errors.
Preferences Cookies
These cookies allow the website to remember choices you've made to provide enhanced functionality and personalization.
Save