Hi All,
Not sure if his is even possible but looking for a vba code to replicate the following.......
I have a large number of files which had permissions set through "right click, properties, security. edit (etc)" so that only the individual and their line manager can access the file from explorer. Unfortunately the person who initiated this didn't seem to anticipate staff changes in the company. this means now the only way to make a change when someone leaves is to manually change each file. Is there a way to bulk change these through VBA.
I know how to loop through a folder and access files individually through VBA but wouldn't have a clue on how or if it is possible to change the permissions.
Any help would be appreciated.
Not sure if his is even possible but looking for a vba code to replicate the following.......
I have a large number of files which had permissions set through "right click, properties, security. edit (etc)" so that only the individual and their line manager can access the file from explorer. Unfortunately the person who initiated this didn't seem to anticipate staff changes in the company. this means now the only way to make a change when someone leaves is to manually change each file. Is there a way to bulk change these through VBA.
I know how to loop through a folder and access files individually through VBA but wouldn't have a clue on how or if it is possible to change the permissions.
Any help would be appreciated.