Password protect an excel file?

[Guest]

Is this possible...I tried clicking 'properties'....'sharing' but it seems a
bit messy as I have 30 employees who need toa access the document.

I wish to give read only access to 27 employees and read write to 3
employees.

- Jason

 

[Jan Karel Pieterse]

Hi,

Is this possible...I tried clicking 'properties'....'sharing' but it seems a
bit messy as I have 30 employees who need toa access the document.

Don't!!!!

Excel is VERY unreliable when it comes to multi-user use. Loss of data,
corruption of the file is your destiny if you take this path.

Seriously consider doing this with e.g. Access.

I wish to give read only access to 27 employees and read write to 3
employees.

Put it in a network folder and set permissions to the entire folder
accordingly.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Guest]

Jason,
I agree with Jan.
That said...
While in the file, select FILE / SAVE AS / TOOLS / GENERAL OPTIONS, then set
one password for 'Password to Open' and another for 'Password to Modify'.
HTH,
Gary Brown