Changing file attribute in an Excel file that is on a network drive

[Shanthan]

We are planning to have our shift schedule at work on a network drive on an Excel file. It will be protected so that it cannot be changed by anyone, except the manager. My original idea was to have the Excel file opened on the manager's computer all the time, so that when the employees open it on any of the other computers, it'll open as read-only and the manager could make changes at any time. Employees just need to close and re-open the file to see the changes.

Problem: If one of the supervisors need to edit the schedule from their office, they won't be able since the file will always remain open in the manager's office.

Question: Is there a way to always open the file as read-only, but when the manager enters a username and password via userform after opening the file, it'll not only unprotect the file, but also change the attribute to write? Or is there any other way to do solve this problem?

 

[BrianMH]

Just set a password to edit it. Anyone can open it to read only. To do this when saving it type the password into "password to modify" instead of "password to open".

 

[Shanthan]

Is there way feature in Excel that allows me to set a password to edit the file or do I have to do this via VBA?

 

[BrianMH]

Yes, click save as and then on the dialog click tools and general options.

 

[Shanthan]

This is great, thanks so much!