-->
Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac.
Applies to: Excel for Mac | PowerPoint for Mac | Word for Mac | Office 2016 for Mac
Jun 16, 2019 Screenshots. Stay organized and manage your day-to-day with Microsoft To Do. Make shopping lists or task lists, take notes, record collections, set reminders and more to improve your productivity and focus on what matters. Microsoft To Do is the task management app that makes it easy to stay organized and manage your life. But anyone who does want to tinker around will have limited options with Macs. Microsoft's Office Suite, which includes apps like Word and Excel, are still best used on a Windows PC instead of.
If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office. For information about VBA for Excel, PowerPoint, and Word, see the following:
Note
Outlook for Mac and OneNote for Mac do not support VBA.
Office 2016 for Mac is sandboxed
Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. You can minimize the effects of sandboxing by using the new commands described in the following section.
Creating an installer or putting user content
For instructions on creating an installer for your add-in, please refer to the article here: Installing User Content in Office 2016 for Mac
New VBA commands for Office 2016 for Mac
The following VBA commands are new and unique to Office 2016 for Mac.
| Command | Use to |
|---|---|
| GrantAccessToMultipleFiles | Request a user's permission to access multiple files at once. |
| AppleScriptTask | Call external AppleScript scripts from VB. |
| MAC_OFFICE_VERSION | IFDEF between different Mac Office versions at compile time. |
Ribbon customization in Office for Mac
Office 2016 for Mac supports ribbon customization using Ribbon XML. Note that there are some differences in ribbon support in Office 2016 for Mac and Office for Windows.
| Ribbon customization feature | Office for Windows | Office for Mac |
|---|---|---|
| Ability to customize the ribbon using Ribbon XML | Available | Available |
| Support for document based add-ins | Available | Available |
| Ability to invoke Macros using custom ribbon controls | Available | Available |
| Customization of custom menus | Available | Available |
| Ability to include and invoke Office Fluent Controls within a custom ribbon tab | Available | Most familiar Office Fluent Control Identifiers are compatible with Office for Mac. Some might not be available. For commands that are compatible with Office 2016 for Mac, see idMSOs compatible with Office 2016 for Mac. |
| Support for COM add-ins that use custom ribbon controls | Available | Office 2016 for Mac doesn't support third-party COM add-ins. |
idMSOs compatible with Office 2016 for Mac
For information about the idMSOs that are compatible with Office 2016 for Mac, see the following:
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Being a Windows program, Microsoft Excel is not natively supported on Chromebooks. However, you will be pleased to know that it is possible to use Microsoft Excel on Chromebook.
Use Microsoft Excel on Chromebook
Although, Chromebooks come preloaded with free software for working on spreadsheets (Google Sheets), many users still prefer using Microsoft Excel.
So, let us go ahead and take a look at different ways to use Microsoft Excel on Chromebook.
1. Download Microsoft Excel on Chromebook
The easiest way to use Microsoft Excel on Chromebook is to download and install the Microsoft Office App on your Chromebook.
If you do not want the entire suite of Office Apps on your Chromebook, you can also download only the specific Microsoft Excel App on your Chromebook.
1. Go to Google Play Store on your Chromebook.
2. Search for the App (Microsoft Office or Microsoft Excel) that you want to download.
Note: Alternatively, you can reach the Excel download page using this link: Download Excel App From Google Play Store.
3. Once you find your preferred App (Office or Excel), click on the Install button.
4. Once the App is downloaded, use the Launcher to open Microsoft Excel App on your Chromebook.
5. Once you are in Excel, you will be required to Sign-in using your personal Microsoft Account or your Account associated with the Microsoft Office Subscription.
The rest is practically the same as working on Microsoft Excel on Windows or Mac.
2. Download and Install Office Online on Chromebook
If you have an older version of Chromebook and it uses Chrome Web Store, you need to download and install Office Online Extension.
1. Go to Chrome Web Store on your Chromebook.
2. Make sure you are the Extensions tab in the side menu and Search for Microsoft Office online.
3. Download and Install the Office Online Extension on your Chromebook.
The Office Online Extension allows you to Create, View, Edit and collaborate Excel files in your web browser.
Working on Microsoft Excel Online is similar to using the desktop version of Excel and it can be accessed from any browser, including Google Chrome.
Unlike the Desktop version, you will need a Microsoft Account to use Excel Online and all your files will be saved to your OneDrive account, instead of being saved to Desktop.
3. Edit Microsoft Excel File Using Google Sheets
The native Google Sheets App on your Chromebook allows you to open, view and edit Microsoft Excel files directly on a Chromebook.
If Google Sheets is not available, you can download the App from Google Play Store and also from the Chrome Web Store.
Do Macs Have Microsoft Excel Online
1. Open the Files App on your Chromebook.
2. Click on Downloads in the Left pane and click on the Excel File that you want to Edit.
3. Make changes to Excel File as required and save the File as an Excel File.
The Edited Excel File will be saved to your Google Drive Account, which you access any time or share with the others.
Google Sheets App supports most Microsoft Excel functions including Pivot Tables, which should be enough for most users.
However, advanced Excel users wanting to use VBA commands will be disappointed; VBA commands do not work on Google Sheets.
Collaboration Tool in Google Sheets
Free Microsoft Excel For Mac
A good feature of Google Sheets is its Collaboration tool, which makes it really easy for multiple people to work on the same file at the same time.
Does Macbook Pro Have Microsoft Excel
This should come as a great news for those who may have tried to use the painful document sharing feature in Microsoft Excel.
Does Imac Have Microsoft Excel
Compared to Microsoft Excel, Google Sheets works a lot better in shared environment and it also makes it so easy to pull live data into spreadsheets (like live currency conversion data).