Putting passwords in VBA code

Hi,

I am trying to understand the best way to deal with passwords in VBA. I have a spreadsheet with multiple sheets that each have the same password. When I run various macros on each sheet it takes off the password and then puts it back on. Currently, however, the password is hard coded into the macro so each time I literally write the password. If the password were to then change for some reason it would mean having to replace all instances of the password throughout the code.

I believe you can declare the password as a global of some kind (if that it the right terminology - apologies I am still very new to VBA) so that you only have to change it in one place.

1. How do you set a password as a "global" for all macros in a project
2. What code do you then use in each macro to refer to this global?

Thanks
MissDB

Regardless, where you put in the password, be it as a global or local, if the VBA project is not password protected, the person can access the code and change the passwords. You can protect the codes with a VBA password and attach the codes to a button, so that the person who wants to use the code can access them by pressing the buttons.

Microsoft office products are not known for good security. Any person with a bit of knowledge can by pass them. I know, I will get in trouble with the site rules, but there are lots of codes which can easily crack a VBA password. Just google it and see what I mean.

Hi,

Yes I know about being able ot change passwords, I am not paritculart worried about that, I don't work in an environment where that is really an issue. The only reason the sheets are password protected is to prevent people accidentally type over things etc.

My query is more about how to put a password in as a global and then how to refer to it in the code so that we don't have to change it in multiple places should it need to change (not how to make it fail safe)

Okay!
Norie has provide you a solution.
"prevent people accidentally type over things etc."
This sound more of protecting the range or sheet using a normal excel password.

Thank you! :-)