user's can no longer edit Excel worksheet

One file.
two worksheets.

Users were able to edit areas of the worksheet until recently. They can no longer do that. When they try to edit, they are prompted with a password. The sheet was always protected, but the users claim they never had to enter a password.

Any ideas?
LVL 19
MontoyaProcess Improvement MgrAsked:
Who is Participating?
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.

Glenn RayExcel VBA DeveloperCommented:
I never believe users who say "I never had to enter a password before!" :-)

One is never immediately prompted to enter a password after a workbook is opened and attempts are made to edit in locked, protected cells.  A message will pop up stating "The cell or chart that you are trying to change is protected and therefore read-only."

Now, if they click "Unprotect Sheet" and a password has been entered previously, then they'll have to enter the password.  It is quite possible that until recently this sheet had been protected without a password, but then someone - accidentally or on purpose - entered a password and saved the file.  

You'll either need to find out what the password was from the individual or crack the password yourself.  There are several free utilities available on the Internet that you can use to do this.  As a rule, I do not crack password-protected files here on EE; it is too risky.

When you do finally get the sheet unlocked, you'll need to re-protect the sheet WITHOUT a password once again, or just forego using one at all.

Good Luck,
MontoyaProcess Improvement MgrAuthor Commented:
I unlocked the sheet a few days ago... what I was looking for is:

Is there a way to have a list of users that can access/edit a file?  I wanted to be sure that there ISNT a feature I did not know about. Is there?
Glenn RayExcel VBA DeveloperCommented:
There's no built-in function - besides the password access - that will limit access to an Excel file.  You can do this with VBA, checking the username against a list of defined names (either embedded in the workbook or VBA module), but that's a little more involved.  I used that functionality to define and control user type in some applications (ex., "users" and "superusers").

byundtMechanical EngineerCommented:
Depending on the version of Excel that you use, there is a provision to permit only certain users to edit certain ranges. In Excel 2013, you access this feature on the Review...Allow Users to Edit Ranges menu item. You will then raise this dialog:
Allow Users to Edit Ranges dialogIf you click the New... button on that dialog, you will see a dialog that lets you specify the protected range
New protected range dialogIf you then click the Permissions... button on that dialog, you will see a dialog that lets you specify the permissions
Permissions for protected range dialogIf you then click the Add... button on that dialog, you can specify users or groups that correspond to that permission:
Select Users or Groups dialog
Excel also has a way of restricting access using the Review...Shared Workbook menu item. Shared Workbooks are notorious for (eventually) resulting in file corruption if multiple users edit the workbook simultaneously. Use of the Shared Workbook feature is discouraged by experts in pretty much every Excel help forum in the world for this reason.

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
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.