Set Password Protection to Excel Application

[suoirotciv]

Sorry, but I already search and only find threads that wants to bypass excell with password.

But for security purpose, we will be sending Credit card information thru email that was created by VB and exported to Excel, and the company want to protect our client information, so we need to protect the excel file with password. And only two person will have access to that password, the one that set the password and the second party that receives the email. Password will not be included in the email (ofcourse). (c",

I already set everything using the faq222-3383 functions suggested by ADoozer <thanks for the help ADoozer>. I set the visible property of the sheet that contains the information to False. But anyone who knows how to use the Alt + F11 can change the properties. So we need to set the protection properties of Excel>VBA to have a password.

"Is this possible using VB?"

Hope anyone have a suggestions or help on this.

Thank you in advance.

Please pardon the grammar.
Not good in english.

 

[johnwm]

Before proceeding too far, you should be aware that password protection on an Excel spreadsheet is normally considered to be rather weak security, as there are plenty of freely available Excel password crackers available.

If you are intending to E-mail credit card information you should look at a much more secure transaction method. If in doubt about the legal consequences, check with your credit card company.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'