I am having this problem today: Working in an excel document, I run a macro that is supposed to write a simple file to the same folder where the excel document resides. I use this for accounting, and it has worked for a few years, last time a few days ago.
Today I made a copy of the excel document in a different folder (new accounting year, new folder). When running the macro, it said access denied. The path is of the form //host/Users/Public/Documents/Year-2015, where "host" is a different computer from the
one I am working at.
Investigating, I opened the File explorer, opened the /host/Users/Public/Documents folder, and clicked on the Properties of Year-2015. The Permissions tab said "All permissions" for user "Everybody". (Actually I have a Norwegian user interface, so I may
possibly translate some of the keywords incorrectly.) But then on the first, or "General" tab, there is a "write protected" checkbox, which is checked. I click on it, and the checkmark goes away, but when I click OK, there is an error message. (Can't remember,
possibly related to Administrator permissions. The user id has local administrator privileges.)
Before trying to remove the checkmark, I opened a Cygwin console, connected to the "host" using SSH, and issued an ATTRIB command on the directory (folder) "Year-2015". No attributes were set.
I then went downstairs to the computer actually hosting the folder. Same procedure, nearly the same result. The check mark was there, and went away. Clicking OK to close the dialog produced no error message. But when I opened the Properties dialog again,
the check mark was there again.
I will now reboot the computer to see if it helps. So long.