Macro/VBA To Set Excel, Word and PowerPoint Preferences

New Contributor

Hi Folks,


Looking for ideas on how to write a macro that I can use to change/set the preferences for Excel, Word, Powerpoint and Outlook on the Mac. Microsoft Office 365 knows they have a problem where the preferences are reset to default when I quit each of these applications (sometimes they are lost after a few days or a few weeks when quitting the applications.) A macro would let me reset the preferences as a work around until Microsoft Office 365 fixes the issue.


Any help is appreciated.

2 Replies

Hi @TheRedOak8! You can´t do this. Excel VBA is hosted only in Excel.Locally without cloud its a Visual Basic stuff to do, but I wouldn´t recommend it..


BUT: As an O365 Admin you can look for Office 365 on Mac devices to manage users being in different permission stages and different account within Office 365 Groups. This Group stuff does not only exist for Exchange and Outlook, but also within all Apps on Office 365. And you can easily manage the permissions in the O365 Admin Center, which user is allowed to use which device in which application.

Please see that short introduction on that topic: https://www.youtube.com/watch?v=b1WhD108W0o


Hope that helps. Greets, Eva.




In this video, we explain Modern Groups, a powerful feature of Office 365. You'll what's included when you create an Office 365 Group, and how it can be helpful for storing group files for better collaboration.

hmm...Eva, the video you suggested is addressing permissions, where I am trying to modify application preferences, like I don't want Excel to auto-fill cells I am typing since I want to ensure the data I am entering is exactly what I am typing. I set this preference by selecting Excel/Preferences/AutoComplete and then unselecting all the check boxes in that dialog box.


How is the group permissions related to setting application preferences?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies