• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help To make user interface with user and password for excel workbook

hello :
could you please help me to make a user interface that request user name and password for excel workbook when i open it and record the login history for the attached sheet i will be gratefull if you helped me
 
This is the file that i want to make the login form for it and i want to be ablw to choose every user authority to access sheets
 

Attachments

  • Segment 2 Interface.xlsx
    12.7 KB · Views: 7
Chek this.
username : deepak
password : kumar
 

Attachments

  • Segment 2 Interface.xlsm
    27.1 KB · Views: 7
I didn't encounter any issue.
Pls change this & let me know.

Code:
Option Explicit

Private Sub Workbook_Open()
Dim ws As Worksheet
Application.ScreenUpdating = False
If Not ActiveSheet.Name = Sheet2.Name Then Sheets("Welcome").Activate
For Each ws In ThisWorkbook.Worksheets
    If ws.Name <> "Welcome" Then ws.Visible = xlSheetVeryHidden
Next

UserForm1.Show
Application.ScreenUpdating = True
End Sub
 
Check this & revert fast as i am feeling sleepy so that next reply would @ tommorow after 10 AM IST.
 

Attachments

  • LogIn_Form.xlsm
    76 KB · Views: 6
the user name is
deepak

You might doing something wrong there.

loop below successful login.

deepak 20-02-2015 0:05
deepak 20-02-2015 0:08
deepak 20-02-2015 0:09
deepak 20-02-2015 0:13
deepak 20-02-2015 0:17
deepak 20-02-2015 0:17
deepak 20-02-2015 0:18
deepak 20-02-2015 0:19
deepak 20-02-2015 0:22
deepak 20-02-2015 0:30
deepak 20-02-2015 0:38
test1 20-02-2015 0:42
tset2 20-02-2015 0:43
hossam 20-02-2015 0:44
hossam 20-02-2015 0:44
hossam 20-02-2015 0:45
deepak 20-02-2015 0:45


New ID are ....


Username Password
deepak kumar
test1 abc
test2 abcd
hossam sadek
 

Attachments

  • LogIn_Form.xlsm
    76.1 KB · Views: 12
dear deepak
thank you but it still the same above issue
forget it now

No need to forget, i will do with another method tommorow. Stay tuned.

Pls let me some info.

OS: It's Win 7 32 or 64 bit
MS Office : It's 2007 with any service pack.

Clear the temp file also.
 
Pls check this.
i will check tomorrow with 64 bit Win7 SP1.

Have a fun.
 

Attachments

  • LogIn_Form.1.xlsm
    77.6 KB · Views: 7
Hi Deepak,
I was succesfully able to open and use it. Thanks Hossam for asking question and thanks deepak for creating.

But still i have few questions.

Would it be possible to know login and logout time also? Also can different workbooks datarecord be opened by admin in single file ? Can few worksheets be hidden inside?

If you want i can upload my version of file here.

Regards,
Maunish Patel
 
Hi Deepak,
I was succesfully able to open and use it. Thanks Hossam for asking question and thanks deepak for creating.

Thnx for the same.

Would it be possible to know login and logout time also?

Ya.

Also can different workbooks datarecord be opened by admin in single file ?

i think might be possible

Can few worksheets be hidden inside?

Why not ?

I request you to start a new post for the same & you may tag this post there too. You are currently hijacking the someone's post here. :)
 
Back
Top