• 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.

unhide very hidden sheets with password access

Afarag

Member
Dears,

i need support in userform VBA, as i have a workbook with 4 spreadsheets
>> Sheet titled "Interface" have a userform Icon to access with user name and passwod
the rest of sheets are very hidden are called "Data 1" & "Data 2" and "Users"

the "Users" have the usernames and passwords that will use to login
need to show "Data 1" & "Data 2" sheets only when login by correct User and Password

Thanks a lot
 

Attachments

  • Unhide.xlsm
    721.5 KB · Views: 6
Hi Afarag,

See the file. I had include a piece of code which will make Data 1 & Data 2 sheets very hidden in Workbook open module.

Then if you enter abc as username and 123 as password than both sheet will become visible.

Regards,
 

Attachments

  • Unhide.xlsm
    723.7 KB · Views: 4
@Somendra Misra ,

thanks a lot for your effort, sorry if the case isn't clear at 1st post,
there is a sheet called "User" that contain the Users and its password that need to give them the access,
need to login with these users,

when fill the password in its field the password is visible, i ask if it will be a symbols as "*****"

thanks,
 
1: The Users will change passwords after that, these password are defaults
2: the username will be unique without any duplication

Gratefully,
 
Ok,

Can I use the table name in retrieving the user as after that i'll have more than one table contains a user for multiple level authorization

Gratefully,
 
Back
Top