Forum Discussion

Copper Contributor

Jan 26, 2019

Macro/VBA To Set Excel, Word and PowerPoint Preferences

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...

Macros and VBA

Eva Vogel

Iron Contributor

Jan 26, 2019

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.

TheRedOak8

Copper Contributor

Jan 26, 2019

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?