Forum Discussion
Macro/VBA To Set Excel, Word and PowerPoint Preferences
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.
- TheRedOak8Jan 26, 2019Copper Contributor
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?