I have a file that was created i think with Excel 2003 or 2007, and i'm using 2010. When you open it, it automatically gives you a prompt for a password. I do know what the password is, BUT i need to change it for a different group so they don't have access to the other file.
It's not saved in the "Save As> Tools" nor is it the Encryption in "File> Permissions". There is a UserForm that comes up to take the password, but the Sub ends after that. I have looked through both modules and can't find that specific password in any of the code.
Any ideas?
It's not saved in the "Save As> Tools" nor is it the Encryption in "File> Permissions". There is a UserForm that comes up to take the password, but the Sub ends after that. I have looked through both modules and can't find that specific password in any of the code.
Any ideas?