password protected button

[kevinexcel]

Hello,

I am trying to create a password protected button in excell. The first person who uses the spreadsheet should only have access to part of the first spreadsheet.

I have already made a button that can unhide all the other worksheets and certain columns in the first worksheet. How to I password protect this button?

Thanks a lot for any help

[Leith Ross]

Hello kevinexcel,

In the macro code for the button, you could check the logged on user's name and compare it to a list of authorized people. If the person is not authorized then exit the macro.

Please Login or Register  to view this content.

[kevinexcel]

Thanks for the response
That is a good idea and I tried it but its not exactly what I need because each user does not have their own log in name.
What is the code to set a password in a similar manner?

[kevinexcel]

bump! Sorry I can not attach a sample but if you need a clearer description please let me know.