excel2003 pasword on open

[nodari]

I have done excel workbook that it always asks passwor to anyone on open, using

Private Sub workbook_Open()

that's OK,

but I need not open this workbook from VBA without password.

how can I organize, can you advice somthing?

 

[Norie]

If you know the password why can't you use it in the code when you want to open the workbook?

 

[nodari]

If you know the password why can't you use it in the code when you want to open the workbook?

I know password, but I don't know how to give it from VBA to userFrom...

 

[Norie]

What userform?

Are you entering the password on a userform and clicking a button to open the workbook?

Or something like this.

If you are it's pretty straightforward to get the password if it's been entered in a textbox or similar.

It would just be something like this, where TextBox1 is where the password has been entered.

strPass = TextBox1.Value

Note - the userform would still need to be loaded for that to work.

 

[nodari]

What userform?

Are you entering the password on a userform and clicking a button to open the workbook?

Or something like this.

If you are it's pretty straightforward to get the password if it's been entered in a textbox or similar.

It would just be something like this, where TextBox1 is where the password has been entered.

strPass = TextBox1.Value

Note - the userform would still need to be loaded for that to work.

I think I have said not understadable.

I need all users opening this worksheet, needs to enter the password into textBox.

and when my VBA opens this workbook, it mustn't ask for a password (mustn't wait for click).