Hiding macro-enabled password
Password protect your project.
Tools - VBA Project Properties - Protection Tab
Check lock project for viewing and supply a password.
This type of password is reasonably secure from being hacked. Note that the
password for the worksheet or workbook are relatively easy to hack with code
easily available on the net.
--
HTH...
Jim Thomlinson
"Brad E." wrote:
I set up my macro to password protect the worksheet and sent the worksheet
on. One user told me what my password is. He simply went to the VBA screen
and saw WS.Protect Password = "MyPassword".
How can I avoid this in the future?
TIA, Brad
|