Solved: Protect vba

[calenger]

Hi All

I have an excel sheet using ado to connect an sql server. I have had to hard code the username ans password and was wondering if there is a way to stop user from opening the vba editor. thus allowing them to see the app account user name and password. Or if there is a better way to allow access to the users. The user accounts do not have access to the sql server.

Thanks

[matthewspatrick]

You can lock the VBA project with a password, preventing people from viewing the code without the password.

However, the security is weak and can be cracked in minutes using easily available tools.

[calenger]

Thanks