Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Protection not working

0

Hello, there!


If I'm not mistaken, workbook/worksheet protected excel file (Microsoft Office Professional Plus 2013) [as the one attatched here] asks no password if opened in a PC with the excel 2007 [but not vice-versa]. When there are several unlocked cells scattered here and there where users are supposed to enter data,  "Allow users to Edit Ranges" doesn't seem so much practical.

Even wps.apk (an android application for word, presentation and spreadsheet) needs no password to edit this file.


Could you help, please?

Thank you!

N.B. Does it happen in other versions, too?
Passwords to unprotect the attatch file:
For workbook: workbook
For worksheet: sheet

Answer
Discuss

Discussion

That sounds odd. I will take a look when im back at my pc but only have office 2016 right now.
don (rep: 1989) Dec 18, '17 at 4:28 pm
When protecting the workbook, did you choose Encrypt with Password or Protect Workbook Structure (same as Protect Workbook on the Review Tab)? Because they don't behave the same way.
don (rep: 1989) Dec 18, '17 at 5:10 pm
 Sorry for the version, it is Microsoft Office Professional Plus 2013 and I've updated in the question, too.

I want users to edit unlocked cells. So, the workbook is not encrypt with password. But I want to stop unnecessary tampering in the locked cells.

For this, I unlocked necessary cells >Review >Protect sheet > set password.

It is perfect when done in 2007 and opened in 2013 (in different PCs) but not vice-versa!

As for other options (2013), going through File > info >Protect Workbook, "Protect current sheet" and "Protect workbook structure" are already  highlighted after sheet and workbook protection are done in the Review tab.

I tried those methods and checked setting, too but to no avail.

Chhabi Acharya (rep: 111) Dec 18, '17 at 10:37 pm
Unfortunately, I do not have access to any other version excel Office 2016 right now. But, Try creating a fresh new file from scratch in Excel 2013 and see if the problem persists.

The protect workbook structure will never do anything to protect the data within specific worksheets by the way.
don (rep: 1989) Dec 22, '17 at 1:33 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login