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

[nishpearl123]

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

 

[jproffer]

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]

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]

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]

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