On a Mac computer, you can save Microsoft Office files to your Stony Brook OneDrive account in either Office 2011 or 2016. (Office 2011 requires Microsoft Document Connection, which may require OS or Safari updates to work.) Office 2016. From your Office 2016 file, select File Save as; From the left menu, select OneDrive - Stony Brook U.
-->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
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.
You can use and share themes among the Office for Mac applications that support themes, such as Word, Excel, and PowerPoint. For example, you can create or customize a theme in PowerPoint, and then apply it to a Word document or Excel sheet. That way, all of your related business documents have a similar look and feel. Dec 21, 2015 I use Word paragraph styles regularly (Office 365 for Mac 2016), and have included in many paragraph style definitions the style for the following paragraph, which saves keystrokes or clicks. Beginning in one of the later updates to Office for Mac 2011, that stopped working in several of my defined paragraph styles. Microsoft word mac apply styles. Select text and apply a style such as a title, header, or paragraph using the Styles gallery.
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.
Remote Desktop Connection
Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office Client Applications and Services team.
Today we are taking a big step forward for Mac® users—Office 2016 for Mac is now available in 139 countries and 16 languages. Based on feedback from the great Mac Office community, we’ve made major updates to each of the apps, and we couldn’t be more pleased to deliver it first to our Office 365 customers.
Unmistakably Office, designed for Mac
The new versions of Word, Excel, PowerPoint, Outlook and OneNote provide the best of both worlds for Mac users—the familiar Office experience paired with the best of Mac.
If you already use Office on a PC or iPad, you will find yourself right at home in Office 2016 for Mac. It works the way you expect, with the familiar ribbon interface and powerful task panes. Mac users will appreciate the modernized Office experience and the integration of Mac capabilities like Full Screen view and Multi-TouchTM gestures. With full Retina® display support, your Office documents look sharper and more vibrant than ever.
Office for Mac is cloud-connected, so you can quickly get to the documents you’ve recently used on other devices and pick up where you left off. New, built-in document sharing tools make it easy to invite teammates to work on a document together. When sharing documents, you won’t have to worry about losing content or formatting, as Office for Mac offers unparalleled compatibility with Office on PCs, tablets, phones and online.
Five modern, first-class applications
![Mac Mac](https://sharepoint.rackspace.com/Learning/PublishingImages/How to sync files on a Mac/maconedrive8.png)
![Microsoft sharepoint Microsoft sharepoint](/uploads/1/2/6/1/126196207/326785216.png)
Microsoft Office For Mac 2016 Free Download
Word for Mac—Word’s powerful writing and reviewing tools make it easy to create great-looking documents. The new Design tab lets you easily apply designer-quality layouts, colors and fonts throughout your document. You can work on the same document simultaneously with your teammates and use threaded comments to have a conversation right next to the corresponding text.
Excel for Mac—The new Excel for Mac helps you visualize your information by recommending charts best suited for your data with chart previews. Familiar keyboard shortcuts, autocomplete and an improved formula builder save you time when creating spreadsheets or entering data. For deeper analysis, new PivotTable Slicers help you filter large volumes of data and discover patterns.
PowerPoint for Mac—PowerPoint’s improved Presenter View gives you full control when you present by showing you the current slide, next slide, speaker notes and a timer on your Mac screen, while the audience only sees your presentation on the big screen. The new animation pane helps you design and fine-tune animations, and the latest set of slide transitions add polish to your presentations.
Outlook for Mac—Managing your email, calendar, contacts and tasks has never been easier. The new Outlook for Mac has push mail support so your inbox is always up-to-date. The improved conversation view automatically organizes your inbox around threaded conversations, so you won’t have to hunt for related messages. And the new message preview shows you the first sentence of an email just below the subject line so you can quickly decide if you want to read it now or come back later.
OneNote for Mac—OneNote is the newest addition to Office for Mac. You can capture your ideas in digital notebooks and access them on any device. Find things quickly with the OneNote search engine that tracks your tags, indexes your typed notes and recognizes text in images and handwritten notes. Bold, italicize, underline or highlight notes, insert files, pictures and tables and organize your notes however you want. You can also share notebooks with friends, family or colleagues so everyone can work together on travel plans, household tasks or work projects.
Made better by Mac users
The customer participation in our Office for Mac preview since its launch in March exceeded our expectations, making it our largest Office for Mac beta ever. Many thanks to everyone who participated in the preview program and helped us improve the product.
Mac preview participants provided us with over 100,000 pieces of feedback. Based on this feedback, we released seven updates in four months with significant improvements in performance and stability. We also added features like improved Mail Merge in Word, Propose New Time in Outlook and support for External Data Connections in Excel.
And the best news is that Office for Mac will continue to see ongoing improvements over time. We plan to release updates and new features for Office 365 customers at least once per quarter.
Available today for Office 365 customers
Office 365 subscribers can get the newest version of Office for Mac today. All you need is an Office 365 subscription (Office 365 Home, Personal, Business, Business Premium, E3 or ProPlus), which includes the rights and access to use Office applications on Mac, Windows, iOS and Android devices, along with additional value in OneDrive and Skype.
Here are a few different ways to get Office 2016 for Mac today:
- Already an Office 365 customer? On your Mac, just browse to your account page (office.com/myaccount), sign in and follow the installation instructions. If you have Office 365 through your organization, go to portal.office.com/OLS/MySoftware.aspx.
- Are you a student? You may get Office 2016 for Mac for free or at a substantial discount. It takes only 30 seconds to find out at office.com/student.
- Otherwise, go to office.com/mac or buy an Office 365 subscription at your local retailer.
Office 2016 for Mac will become available as a one-time purchase option this September.
We hope you’re as excited as we are about the new Office for Mac. It’s one of many important releases this summer where we are improving the Office experience across devices and platforms. We released Word, Excel and PowerPoint for Android phones just two weeks ago, which join Outlook and OneNote for Android phones, and we are just weeks away from delivering Office Mobile apps for Windows 10.
Please keep sending us your feedback and suggestions, and we will continue to improve your Office experience.
—Kirk Koenigsbauer
*Apple, Mac, Retina and Multi-Touch are registered trademarks of Apple Inc.