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
LVL 1
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John CarneyReliability Business Tools Analyst IIAuthor Commented:
Actually it would be enough to avoid the dialog box altogether and just automatically open the workbook read-only for everyone except me.
Kanti PrasadCommented:
Hi

1.On the Review tab, under Protection, click Permissions, and then click Restricted Access and then protect and share workbook.

Once you enter a password other can only read it

Please have a look at the below link to get many other types of options
https://support.microsoft.com/en-us/kb/289270#/en-us/kb/289270

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Thanks!
Rob HensonFinance AnalystCommented:
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 ]IT Services ConsultantCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.