Excel 2013 issues with Worksheet Protect in VBA

[Kraglin1]

Hey all,

I'm running into a very frustrating issue with an Excel file my company uses. This is a multi-worksheet, heavily macroed/VBAed, tool my company uses. I currently develop/manage it with Excel 2007.

In the Workbook_Active() event I protect several sheets with a password. If an Excel 2013 user opens the file, the password protect works properly. If they then save and send that file to an Excel 2010 user, the Workbook_Activate() event fires, the worksheet.protect method attempts to (re)protect the sheet and subsequently generates an error that the provided password is not correct.

It appears that just by opening and saving the file in Excel 2013 that the password used to protect the worksheets gets "changed"

Here's the crazy part. If the 2010 user who gets the error sends me the file, it opens just fine in 2007.

I know there is a different encryption algorithm in use in worksheet protection in Excel 2013, but I'm a little baffled why I don't see the problem with the file on my system, but the 2010 user does.

Has anyone seen anything similar?

[Kraglin1]

I've attached a stripped down version of what the big sheet does. This has been opened and saved under Excel 2013. Excel 2010 users opening this file will probably see an error that the password is not correct. Excel 2007 (and 2013) should see no issues.

And go...