Password unprotect excel workbook depending of environ id:

[pedie]

Hi, can macro be enabled before workbook is unprotected so that it runs thisworkbook open code and unprotect the workbook by itself user dont have to actually unprotect the workbook?

When i ask this, i dont mean open workbook from another workbook...

Thanks for any advice.

 

[VoG]

Hi. Do you mean like this?

Private Sub Workbook_Open()
If Environ("username") = "Pedie" Then Me.Unprotect Password:="Pedie"
End Sub

 

[pedie]

Peter, thanks. I tried this way but it still promts me for password...and now i think the password i supplied is also wrong...it won't even open up with the correct password:


Thanks again

 

[VoG]

Sorry, we cannot help with lost passwords.

 

[pedie]

Peter....i do not want to bypass it.
I know the password it is "123" testing password.

It still pops up password dailog box even though i have conditioned my environ's id correcly.

 

[VoG]

Check your Caps Lock settings.

 

[pedie]

I exactly tried this way and it still ask me for password:

[/FONT]
[FONT=Courier New]Private Sub Workbook_Open()
Application.DisplayAlerts = False
 'MsgBox "Ooops!"
 If Environ("Username") = "Pedie" Then Me.Unprotect Password:="123"
Application.DisplayAlerts = True
End Sub

Thanks again Peter!

 

[VoG]

Sorry but you must have mis-typed the password when you saved it. I cannot help you but Google can.