Password for workbook

I have successfully password protected my workbook AND the VB code, hidden
all worksheets except one that states 'macros must be enabled', and all in
all I'm pretty chuffed. The only problem is, when the password is entered
into the input box, it can be read by anyone looking over my shoulder! This
may seem pretty dumb, but can anyone tell me how to disguise the password
upon entry?

Call a userform from your Workbook_Open code. Userform Textboxes can
have hidden text (set the Passwordchar property to True).

However, you should realize that anyone with enough skill to find these
newsgroups can easily bypass all your protection, so you shouldn't rely
on it for sensitive information:

http://www.mcgimpsey.com/excel/removepwords.html

and

http://www.mcgimpsey.com/excel/fileandvbapwords.html



In article <5aa3dcc3130b7@uwe>, "Smarty" <u17872@uwe> wrote:

> I have successfully password protected my workbook AND the VB code, hidden
> all worksheets except one that states 'macros must be enabled', and all in
> all I'm pretty chuffed. The only problem is, when the password is entered
> into the input box, it can be read by anyone looking over my shoulder! This
> may seem pretty dumb, but can anyone tell me how to disguise the password
> upon entry?

I've done it! Thanks for your help, it all seems to work fine!

JE McGimpsey wrote:
>Call a userform from your Workbook_Open code. Userform Textboxes can
>have hidden text (set the Passwordchar property to True).
>
>However, you should realize that anyone with enough skill to find these
>newsgroups can easily bypass all your protection, so you shouldn't rely
>on it for sensitive information:
>
> http://www.mcgimpsey.com/excel/removepwords.html
>
>and
>
> http://www.mcgimpsey.com/excel/fileandvbapwords.html
>
>> I have successfully password protected my workbook AND the VB code, hidden
>> all worksheets except one that states 'macros must be enabled', and all in
>> all I'm pretty chuffed. The only problem is, when the password is entered
>> into the input box, it can be read by anyone looking over my shoulder! This
>> may seem pretty dumb, but can anyone tell me how to disguise the password
>> upon entry?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1