password proteced sheet in office 2013 opens without password in office 2007

nishpearl123

Board Regular
Joined
Jun 14, 2010
Messages
96
Hi,

1. Created a macro file in office 2013
2. Password protected sheets
3. Now, when opened this file office 2007, to my surprise, it unprotected sheet without asking password!!!

How is this possible? This is so unsecure...

Please help to resolve this issue

Eagerly await your reply.

Regards,
Ni****h Sanghvi
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,643
If you open it in Excel 2013, are they locked again?

Excel "security" is not at all secure, but what you describe shouldn't have happened unless something told it to remove the protection.

Is there any code in your workbook? Especially in the Workbook module?
 

nishpearl123

Board Regular
Joined
Jun 14, 2010
Messages
96
Hi,

Thnx for such a speedy reply.

Now, when i opened the same workbook again in 2013, it gets unprotected without password in 2013 also!!!

Means all passwords are removed once i open this password protected sheets in 2007?

This is really unseure...

Any solution???
 

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,643
Truly secure solutions? No

Excel security is basically mis-named, as it's not secure at all.

Is there any code in your workbook module that might be unprotecting sheets upon the opening event of the workbook?
 

nishpearl123

Board Regular
Joined
Jun 14, 2010
Messages
96
No, there is no such code...

But I just tried one workaround...

Instead of protecting the sheet from the Excel Menu, I this time protected it form workwook vba code...

So everytime the file opens it protects it with password..

Then I opened this file in office 2007 & it worked!!!

Now, I looking as to how to write all the options of Protecting in vba becoz of wish to allow certain things...

Thx for your precious time...

Pl. see if something can be done normally
 

Watch MrExcel Video

Forum statistics

Threads
1,109,251
Messages
5,527,636
Members
409,778
Latest member
MagalieD

This Week's Hot Topics

Top