ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Prevent users from changing the password (https://www.excelbanter.com/excel-discussion-misc-queries/81575-prevent-users-changing-password.html)

roel1973

Prevent users from changing the password
 
I have a file that is on a shared drive that multiple users use. The file is
not saved as a shared workbook. The file is password protected and all users
know the password. Is there a way to prevent users from changing the password
when they are re-protecting the workbook after they have made changes?

I also have found that if I protect a workbook some one who has the password
can then protect and share the work book putting a new password over mine
thus not allowing me to edit the workbook. Is there any way to restrict users
from doing this?


Jim Rech

Prevent users from changing the password
 
Is there a way to prevent users from changing the password
when they are re-protecting the workbook after they have made changes?

No but what do you mean 're-protecting'? They just have to do a quick
Ctrl-s to save not go through the whole protect procedure again. The
password sticks until changed.

--
Jim
"roel1973" wrote in message
...
|I have a file that is on a shared drive that multiple users use. The file
is
| not saved as a shared workbook. The file is password protected and all
users
| know the password. Is there a way to prevent users from changing the
password
| when they are re-protecting the workbook after they have made changes?
|
| I also have found that if I protect a workbook some one who has the
password
| can then protect and share the work book putting a new password over mine
| thus not allowing me to edit the workbook. Is there any way to restrict
users
| from doing this?
|




All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com