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