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!
Bookmarks