One way to share information from your Mac is by setting permissions in your folders. As you might expect, permissions control who can use a given folder or any disk (or partition) other than the startup disk.
If a public folder does not have an email address assigned to it, you cannot use Outlook 2016 for Mac to post a message in the folder. To view your subscribed public folders, in the navigation pane, click Subscribed Public Folders. Every file and folder on your Mac has a configurable set of permissions. Permissions control three types of access: reading, writing, and executing. You can mix and match any of the types to grant seven levels of access, as illustrated below. Read, write, and execute permissions overlap to create seven octal permission notations. Why is the calendar permissions button greyed out in Outlook 2016 for Mac? Tags calendar outlook permissions shared-mailbox This issue occurs if the Group similar folders, such as Inboxes, from different accounts check box is selected and the Hide On My Computer folders check box is cleared in General Preferences. On your Mac, choose a file or folder. Right-click it and select Get info. Click the disclosure triangle in the Sharing & Permissions block. Click the lock icon to unlock it. How to reset user Home folder permissions on Mac (reset ACL) Information. In order to perform necessary operation you should boot your Mac into OS X Recovery. Restart your Mac and hold down Command+R keys until you Apple logo appears on the screen.
Why can’t you share the startup disk? Because macOS won’t let you. Why not? Because the startup disk contains the operating system and other stuff that nobody else should have access to.
You can set permissions for
- The folder’s owner
- A subset of all the people who have accounts on the Mac (a group)
- Everyone who has the Mac’s address, whether they have an account or not (guests)
To help you get a better handle on these relationships, a closer look at permissions, owners, and groups is coming right up.
Contemplating permissions
When you consider who can use which folders, three distinct kinds of users exist on the network. Here’s a quick introduction to the different user types:
- Owner: The owner of a folder or disk can change the permissions to that folder or disk at any time. The name you enter when you log in to your Mac — or the name of your Home folder — is the default owner of Shared folders and drives on that machine. Ownership can be given away. Even if you own the Mac, you can’t change permissions for a folder on it that belongs to another user (unless you get Unix-y and do so as root). The owner must be logged in to change permissions on his folders.
macOS is the owner of many folders outside the Users folder. If macOS owns it, you can see that “system” is its owner if you select the folder and choose File → Get Info (or press ⌘+I).
Folders that aren’t in the User directories generally belong to system; it’s almost always a bad idea to change the permissions on any folder owned by system.
If you must change permissions on a file or folder, select its icon and choose File → Get Info (⌘+I) and then change the settings in the Sharing & Permissions section at the bottom of the resulting Get Info window. Don’t change permission settings if you’re not absolutely sure of what you’re doing and why. And by all means think twice before deciding to apply changes to all the items in a folder or disk; change permissions on the contents of the wrong folder and you could end up with a mess.
- Group: In Unix systems, all users belong to one or more groups. The group that includes everyone who has an account with administrator permissions on your Mac is called Admin. Everyone in the Admin group has access to Shared and Public folders over the network, as well as to any folder that the Admin group has been granted access to by the folder’s owner.
For the purpose of assigning permissions, you can create your own groups the same way you create a user account: Open the Users & Groups System Preferences pane, click the little plus sign, choose Group from the New Account pop-up menu, type the name of the group, and then click the Create Group button.
The group appears in the list of users on the left, and eligible accounts appear with check boxes on the right.
- Everyone: This category is an easy way to set permissions for everyone with an account on your Mac at the same time. Unlike the Admin group, which includes only users with administrative permissions, this one includes, well, everyone (everyone with an account on this Mac, that is).
If you want people without an account on this Mac to have access to a file or folder, that file or folder needs to go in your Public folder, where the people you want to see it can log in as guests.
Sharing a folder
Suppose you have a folder you want to share, but it has slightly different rules than those set up for the Public folder, for the Drop Box folder within the Public folder, or for your personal folders. These rules are permissions, and they tell you how much access someone has to your stuff.
Actually, the rules governing Shared and Public folders are permissions, too, but they’re set up for you when macOS is installed.
It is suggested that you share only those folders located in your Home folder (or a folder within it). Because of the way Unix works, the Unix permissions of the enclosing folder can prevent access to a folder for which you do have permissions. If you share only the folders in your Home folder, you’ll never go wrong. If you don’t take this advice, you could wind up having folders that other users can’t access, even though you gave them the appropriate permissions.
By the way, you can set permissions for folders within your Public folder (like the Drop Box folder) that are different from those for the rest of the parent folder.
Don’t forget that anything said about sharing a folder also applies to sharing any disk (or partition) other than your startup disk. Although you can’t explicitly share your startup disk, anyone with administrator access can mount it for sharing from across the network (or Internet).
To share a folder with another user, follow these steps:
- Open System Preferences.The System Preferences window appears.
- In the System Preferences window, click the Sharing icon.The Sharing System Preferences pane appears.
- Click File Sharing in the list of services on the left.The lists of shared folders and their users appear on the right.
- Click the + (plus) button under the Shared Folders list or drag the folder from the Finder onto the Shared Folders list to add the folder you want to share.If you select the Shared Folder check box in a folder’s Get Info window, that folder already appears in the list of Shared Folders, so you won’t have to bother with Step 4.Alas, although selecting the Shared Folder check box in a folder’s Get Info window causes it to appear in the Sharing System Preferences pane’s Shared Folders list, you still have to complete the steps that follow to assign that folder’s users and privileges.
- Click the + (plus) button under the Users column to add a user or group if the user or group you want isn’t already showing in the Users column.
- Click the double-headed arrow to the right of a user or group name and change its privileges.You can choose among three types of access (in addition to no access) for each user or group. If you’re the folder’s owner (or have administrator access), you can click the padlock icon and change the owner and/or group for the file or folder.
Permission | What It Allows |
Read & Write | A user with Read & Write access can see, add, delete, move, and edit files just as though they were stored on her own computer. |
Read Only | A Read Only user can see and use files that are stored in a Shared folder but can’t add, delete, move, or edit them. |
Write Only (Drop Box) | Users can add files to this folder but can’t see what’s in it. The user must have read access to the folder containing a Write Only folder. |
No Access | With no permissions, a user can neither see nor use your Shared folders or drives. |
Problems with Apple’s sandbox requirements in Mac Office 2016 and higher with VBA code
In Windows Excel 97-and higher and in Mac Excel 2011 you can open files or save files where you want in almost every folder on your system without warnings or requests for permission. But in Mac Office 2016 and higher Microsoft have to deal with Apple’s sandbox requirements. When you use VBA in Mac Excel 2016 or higher that Save or Open files you will notice that it is possible that it will ask you permission to access the file or folder (Grant File Access Prompt), this is because of Apple’s sandbox requirements.This means that when you want to save/open files or check if it exists with VBA code the first time you will be prompted to allow access on the first attempt to access such a folder or file.
How to avoid problems
There are a few places on your Mac that you can use to avoid the prompts and let your code do what it needs to do without user interaction. But these folders are not in a place that a user can easily find so below are some steps that I hope to make it easier for you to access the folder manual if you want.
This is the Root folder on my machine that we use in the examples on this page:
/Users/rondebruin/Library/Group Containers/UBF8T346G9.Office
Note: rondebruin is the user name in this path and I agree that the naming of the folder for Office(UBF8T346G9.Office) is not so nice, but Microsoft must use that of Apple.
The folder above you can use to share data between Office programs or with a third party application, so this location will always work if you want to have read and write access. If you want to have a location only for Excel for example use this path : /Users/rondebruin/Library/Containers/com.microsoft.Excel/Data/Users/rondebruin/Library/Group Containers/UBF8T346G9.Office
Note: rondebruin is the user name in this path and I agree that the naming of the folder for Office(UBF8T346G9.Office) is not so nice, but Microsoft must use that of Apple.
I not use this location on this example page to be sure that every Office program can access my files if this is needed. To get this Excel path you can also use Environ('HOME') or Environ('CFFIXED_USER_HOME')
Manual create a folder for your Excel files in the Office folder
- Open a Finder Window
- Hold the Alt key when you press on Go in the Finder menu bar
- Click on Library
- Open the Group Containers folder
- Open the UBF8T346G9.Office folder
- Create a Folder inside this folder named MyExcelFolder for example
- Select this folder
This are three ways to easily open the folder manual :
- Add it to your Favorites in Finder by dragging it to it.
- Add it to your Favorites in Finder with the shortcut : cmd Ctrl T
- Drag the folder to the Desktop with the CMD and Alt key down. You now have a link(alias) to the folder on your desktop so it is easy to find it and open it in the future.
Note : Adding the folder to your Favorites is my favorite because you see the folder in your open and save dialogs in Excel.
![Download Download](/uploads/1/1/9/6/119618569/301180577.jpg)
Or use this script one time to create a folder for your Office files and create shortcuts to a few important folders, check out this page : Setup your Mac for Mac Office 2016 or higher
How to create a Folder in the Office folder with VBA code
Below you find a macro and a function that you can use to create a folder if it not exists in the Root folder named : UBF8T346G9.Office
In the macro you see one line that call the function and the argument is the name of the folder that you want to create if it not exists. Change 'MyProject' to something else to create another folder.
How do I open files with VBA code in my folder ?
Network Directory Permissions
Below you find a macro and a function that you can use to open a file in one of the sub folders of the UBF8T346G9.Office folder. In the macro you see one line that call the function and there are two arguments :
- Name of the sub folder
- Name of the file
Note : You can also add code in the macro to test if the file is already open, I use that also in the code example in this section : Browse to a file or files in a sub folder of the Office folder.
How do I Save a file with VBA code in my folder ?
Windows Directory Permissions
The first macro create a file of only the activesheet and save it in a folder named: ProjectName and the second macro save a copy of the file in a folder named Backup. Both are sub folders of your UBF8T346G9.Office folder. Be sure you update your Mac Office install so it is 16.9 or higher.
Directory Permission 0216 For Mac Os
Note : Both macros use the custum function CreateFolderinMacOffice that you find in the first section of this page.
Browse to a file or files in a sub folder of the Office folder
In the example below it opens a browse dialog with a folder folder named : MyExcelFolder from your UBF8T346G9.Office folderand you are only able to select xlsx files. Below the macro you find a list of format names and you can read how you can change it. Note: Do not forget to copy the bIsBookOpen function in your module, you find it below the macro.
Other file formats :
In the macro you see this code line that say which file format you can select (xlsx).
FileFormat = '{'org.openxmlformats.spreadsheetml.sheet'}'
If you want more then one format you can use this to be able to also select xls files.
FileFormat = '{'org.openxmlformats.spreadsheetml.sheet','com.microsoft.Excel.xls'}'
This is a list of a few formats that you can use :
xls : com.microsoft.Excel.xls
xlsx : org.openxmlformats.spreadsheetml.sheet
xlsm : org.openxmlformats.spreadsheetml.sheet.macroenabled
Directory Permission Denied
xlsb : com.microsoft.Excel.sheet.binary.macroenabled
csv : public.comma-separated-values-text
doc : com.microsoft.word.doc
docx : org.openxmlformats.wordprocessingml.document
Directory Permission 2016 For Mac Free
docm : org.openxmlformats.wordprocessingml.document.macroenabled
ppt : com.microsoft.powerpoint.ppt Lan scan mac download windows 10.
pptx : org.openxmlformats.presentationml.presentation
pptm : org.openxmlformats.presentationml.presentation.macroenabled
txt : public.plain-text
Directory Permissions Windows 10
More information
See this page for more information about selecting files in Excel 2011 and Excel 2016 and higher
See this page for more information about the file format numbers
FileFormat numbers in Mac Excel