Hello Excel Experts,
how can I require other users to enter password if they try to make changes to any of the file content?
PS. If I open it to modify, no need for password. If others open it to modify, ask for password. No password required for Read-only.
in another word, I have excel file saved on shared drive, or on the network, that is mine, or created by me. I would like to have it available to others but as read only.
I want to be able to open and modify the file without password from my PC, or login. however, if other users opens it (not from my PC, or Login) I want Excel to prevent any changes by others unless they input the password.
I hope I got it explained correctly.
thanks for the help.
how can I require other users to enter password if they try to make changes to any of the file content?
PS. If I open it to modify, no need for password. If others open it to modify, ask for password. No password required for Read-only.
in another word, I have excel file saved on shared drive, or on the network, that is mine, or created by me. I would like to have it available to others but as read only.
I want to be able to open and modify the file without password from my PC, or login. however, if other users opens it (not from my PC, or Login) I want Excel to prevent any changes by others unless they input the password.
I hope I got it explained correctly.
thanks for the help.