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.

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.

Yes I think this would be the solution, do you know of any sites showing how
it has been used?

"Cody" wrote:

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.

Try running a search for "xlVeryHidden" on this site and on MrExcel. You
could always set up your forms and sheets as far as you can take it. Then
any additional coding you can get help on more specifically.

"Kieran" wrote:

Yes I think this would be the solution, do you know of any sites showing how
it has been used?

"Cody" wrote:

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.