Depanted of the UserName and Password when a workbook is opened.

[MariaPap]

Hello

What i mean in my title is this.

When i open a workbook i need to ask a username and a password. If the use type as UserName "Maria" and Password 123, then a welcome message should appear and open userform1 in sheet1.

If user type as UserName " John" and Password 589, then code should delete all data in sheets, "one", "two",five" and THEN a welcome message should appear and open userform1 in sheet1.

Can you help me on this?

Thanks in advance for any assistance!

[Kyle123]

What does "depanted" mean?

[MariaPap]

"Depanted " means that if the user chooses, UserName "Maria" and Password 123,then do this OR if the user chooses " John" and Password 589, then do something else. Sorry for my English.

"When i open a workbook i need to ask a username and a password. If the user type as UserName "Maria" and Password 123, then a welcome message should appear and open userform1 in sheet1.

If user type as UserName " John" and Password 589, then code should delete all data in sheets, "one", "two",five" and THEN a welcome message should appear and open userform1 in sheet1."

[Kyle123]

Ah right, got you, the word you're after is dependant

Must it have a password? Generally these types of things are easier if you just look at who is currently logged onto the computer and use that instead of having to keep a password also.

[MariaPap]

Thank you of looking on my problem and also for the English Lessons!!

What i need is this. If for any reason someone "force" me to open this workbook even that i don't want to see my data, i'll give him-her the second password. Then Data in sheets one, two, five, will automatically deleted and he-she will see only the data of the other sheets which is ok for me...

I hope this to be more clear.

[john55]

just a thought, if she/he forces you to save the file? what do you do? have you got a plan "b"?!
or another approach maybe

[MariaPap]

Yes. My idea is when workbook is opened using

Please Login or Register  to view this content.

the userform3 which will asks for username & password will appears.

As userform is opened clicking the save button nothing saved. So you have to close this userform. When this userform is closed without to type the correct username & password, data in sheets one,two.five, will automatically deleted.

Ok. Then they can force me to save the file.

So any suggestions John?

[Fotis1991]

As you know i am not a VBA expert but i am Greek!!-Same way of thinking-

I don't know how to compine 2 text boxes for using Username and password.. but here is what i can do..

In UserForm3 Create a text box1 that will be the place that will type your password. Also a Command Button for confirming this,

Then try this...

Please Login or Register  to view this content.

I hope that someone vba expert will be able to make it better.

[MariaPap]

If you were a VBA expert, what would happen...?

Mr Foti, this works great. I don't know if any of the repliers has a better idea, but this works exactly as i expected!

Thanks for one more time! I don't mark this as solved for a while-in case that someone else would be able to make another suggestion!

[john55]

As an option, UserForm1 is for UserName and Password having 2 TextBoxes and a CommandButton, UserForm2 is just another UserForm, try to incorporate/adapt it in your file.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Fotis1991]

Maria.

Reading John's post, i hope to understand that this is a proffesional approach and mine not!!

John one point is that when the user leave the 2 textboxes empties, the the order of your code is to save the book and exit! Correct?

If yes, how can we handle the point that after clicking the button appears the custom form of excel asking if we want to save it or...or cancel...?

Edit: Actually the message is for all the workbooks that are in use.

[john55]

Fotis, thx but it's not a professional approach at all, it's just an option! the file is not saved, it just makes it look like it's saved.

[MariaPap]

That's great John! Thank you.

Thanks to all three of you(Kyle 123, for English lesson too!)