I am not sure myself how to start fooling with the password protection as it
is built into excel. However, you could always use the xlVeryHidden command
to hide the worksheet on opening of the workbook. When the password code is
completed then show the sheet.


"Kieran" wrote:

I'm a confident user of excel, and have slowly been getting in harder code,
I'm curretly trying to make workbook with a worksheet unprotected when you
open the file, I then want to be able to click a button and have a form apear
(i can do this no probs) but i start having problems when i try to have a box
so you put in a password in a text box (password appears in asterix i can do
this fine) and if the passwords is correct it opens a protected work sheet, i
can't do this, but also i would like to know how to make it auctomatically
protected if i leave that worksheet.

If anybody knows of any sites that will help, or know where i can view a
simiar document then plz message me.