asked on

Saving a workbook so that everyone but me needs a password to open it with write privileges

How do save a workbook so that everyone but me needs a password to open it with write privileges. I want them to be presented with a password dialog box to gain write privileges, but I don't want to have to have to enter the password every time I open it. I imagine it will require some kind of Environ("Username") code in a WorkbookOpen sub, but maybe Excel already has some built-in functionality to accomplish that.

Thanks!
John

John Carney

ASKER

Actually it would be enough to avoid the dialog box altogether and just automatically open the workbook read-only for everyone except me.

ASKER CERTIFIED SOLUTION

Kanti Prasad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Carney

ASKER

Thanks!

Rob Henson

Shared workbooks have a lot of issues with them. It is a feature that is renowned for being unreliable.

I would just protect the workbook with a password that only you know, others cannot then have write access to the file.

What is the point of having a password if you are going to share it with people?

Thanks
Rob H

[ fanpages ]

Rob, I (& many other long-term 'Experts' here) will agree with you about the anticipation of shared workbooks eventually becoming corrupted, but I think the point about the password is as follows:

"...needs a password to open it with write privileges. I want them to be presented with a password dialog box to gain write privileges".

Hence, I read the question as a requirement for a "read/write" password facility, as well as providing a "read only" entry option.

This can be achieved without converting the workbook to a shared workbook.