I have created a book and protected individual sheets. Entered the password as usual (twice), closed to book and reopened, entered the password and it doesn't work. Get error saying to check caps lock... Before saving I checked the password and it was fine. Please help, do I need to enable something?
How do I ensure that the visual basics aren't interfering with my access? Read this could be the issue.
Found this entry:
I have had the same problem. Mostly when I have set protection of Visual Basic. It seems the two protections inhibit access to the creator. Everything within the file seems to work properly except the password access, even if it IS the correct password."