Require VBA code to user form with hidden sheet feauture

[brightwayhr]

Hi ,

The login form should have access to multiple admin and sub user, Where the admin can give access only to few sheets to there sub user for editing and other sheet has to be hidden.

I require VBA code.

 

[brightwayhr]

Yeah Mike,

First I created a new workbook and saved as Macro format

Renamed the sheet1 As home
Sheet2 as user,3 as shared, 4 as Jane and 5th as Bob.

In home sheet I just typed the user name password as per above image.

Opened VBA editer and Top in this workbook pasted the code.

Inserted new module and pasted the code as above.

Created a userform.
Double click and created new 2 label and named as username and password.

Created a two text box for user name and password.
Then double clicked on userform and pasted the userform code.

After save when I opened am getting an error as run time error 424 object required as mentioned above. I don't see any userform to login And then debug it indicates in yellow colour as userform1.submitpassword.

These are the only step I followed.

Looking forward for u r response thank you for your support MiKe.

 

[mikerickson]

You need a third Label and a command button.

 

[brightwayhr]

Hello Mike,

Hope you are doing Great!

Finally I got the user form but again syntax error caption, Truefocus*****=start

And the form shows I tried login but it says no such user found all sheets was hidden only able to view home screen.

Below is my form link how it looks like .

https://www.dropbox.com/s/ype3flf4n5n7mx8/Photo 14-10-16, 3 01 40 PM.jpg?dl=0

Thank you mike.

 

[mikerickson]

For some reason the profanity editor on this site takes exception to T a k e F o c u s O n C l i c k which is what that property should be (without the spaces).

 

[brightwayhr]

I didn't get you Mike? Can you elobrate.

 

[sureshtrb]

Useful one
When login through admin only Home, Users, and Shared is showing. Bob and Sheets are hidden even though the User sheet cells are empty under their name in the admin row. Any suggestions?