Rookie Mistake (Password-related)

I used this (very wrong) line of code to specify that I wanted to be able to format rows when protecting my worksheet with VBA:

ActiveSheet.Protect (AllowFormattingRows = True)

Instead of doing what I wanted it to do, it created a password for the worksheet. Can someone please tell me what password was created? I've tried several obvious versions of what's in parentheses, but to no avail.

The PasswordBreaker macro that I'm familiar with doesn't seem to want to play nicely, and I'd rather not modify the XML, as it seems like a recipe for file corruption.

All help appreciated!

Thanks!

The simplicity of this answer is embarrassing... Thank you, Greg! Admittedly, my curiosity will still be wondering what the password was!

Not sure if this is considered hacking, but

my curiosity will still be wondering what the password was!

The answer is Logical.

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Incidentally, the worksheet will be unprotected if you run:

Please Login or Register  to view this content.

but trying to unprotect it from the Ribbon "Unprotect Sheet" button will NOT work when you enter "False" (without quotes) as the password. It may be associated with "False" being treated as a Boolean variable in one instance and as a String variable in the other. I'm happy to be educated on this point.


Best regards,

Greg M

but trying to unprotect it from the Ribbon "Unprotect Sheet" button will NOT work when you enter "False" (without quotes) as the password.

It will if you put it all in caps.

Hi Fluff,

Now that IS a nasty trick!!!

When I run the following code:

Please Login or Register  to view this content.

the message box displays "False" (without quotes), so it's a bit mean to have the password entered as "FALSE" (again without quotes)!

Thank you for furthering my education.

Regards,

Greg M

I suspect it's because Excel uses TRUE & FALSE as boolean values, whilst VBA uses True & False.
Just another thing to cause headaches.

Indeed so! Thanks again.

My pleasure.

Bonus points to all! Thank you both!

Glad to help & thanks for the feedback.

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M