Excel 2007 : Password Mismatch in macro

[ChemistB]

With Excel 2000, I used the following line of code to allow Excel to run macros on the protected spreadsheet. The password in the line of code did not have to match the password used to protect the sheet (which often changes).

Please Login or Register  to view this content.

In Excel 2007, it gives me an Incorrect Password error, implying that the macro password must match the sheet password?
Thanks in advance?

[shg]

I'm amazed you don't have to match the password in any version of Excel, Chemist. Otherwise, you're changing the password without knowing the old one.

Very curious.



You sure about that?

[ChemistB]

Yep, positive. I figured that was one of the reasons why Excel is not considered Part 11 compliant as that creates a huge gap for anyone knowing VBA. If the spreadsheet wasn't protected when the macro was run, the code would run through and then it would assign the password in the code (e.g. "testing") but if it was already protected, the code would run fine and the sheet password would remain unchanged. The code would not run without that line however.

Okay, this makes things more complicated but not impossible. I'll need to have the password on a very hidden sheet and refer to that password in the code. Thanks SHG.

[shg]

You can embed the password in a public constant in the code ...

[ChemistB]

I could but the passwords are enabled by our Document Group who are not very Excel savy. Thanks again.