Password for workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smarty - 20 Jan 2006 13:15 GMT

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?

Reply to this Message

JE McGimpsey - 20 Jan 2006 15:51 GMT

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?

Reply to this Message

Smarty - 26 Jan 2006 10:12 GMT

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

>Call a userform from your Workbook_Open code. Userform Textboxes can
>have hidden text (set the Passwordchar property to True).
[quoted text clipped - 15 lines]
>> may seem pretty dumb, but can anyone tell me how to disguise the password
>> upon entry?

Reply to this Message