Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code
Hello everubody.
i would like to have a code that ask for a password to Unhide a sheet, it is related the variable salaries for our employees, and one should not see the other, so, I am looking for a drop-down list and when the associate select his/her name on the list the code ask for a password before unhide the spreadsheet. I really appreciate a help. -- regards from Brazil Thanks in advance for your feedback. Marcelo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code
Hi Marcel
Do not ever put confidential information in a file like that, it is very accessible to any medium skilled user. Hiding sheets or parts of sheets is not safe. Assume that any user can and may see all parts of an excel file. Sorry for this reply, what you ask is pretty simple to make, but it is not safe. (Oh, I mentioned that already :-) HTH. Best wishes Harald "Marcelo" wrote in message ... Hello everubody. i would like to have a code that ask for a password to Unhide a sheet, it is related the variable salaries for our employees, and one should not see the other, so, I am looking for a drop-down list and when the associate select his/her name on the list the code ask for a password before unhide the spreadsheet. I really appreciate a help. -- regards from Brazil Thanks in advance for your feedback. Marcelo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code
I totalu agree with you, I will have one file for each guy.
thanks a lot -- regards from Brazil Thanks in advance for your feedback. Marcelo "Harald Staff" escreveu: Hi Marcel Do not ever put confidential information in a file like that, it is very accessible to any medium skilled user. Hiding sheets or parts of sheets is not safe. Assume that any user can and may see all parts of an excel file. Sorry for this reply, what you ask is pretty simple to make, but it is not safe. (Oh, I mentioned that already :-) HTH. Best wishes Harald "Marcelo" wrote in message ... Hello everubody. i would like to have a code that ask for a password to Unhide a sheet, it is related the variable salaries for our employees, and one should not see the other, so, I am looking for a drop-down list and when the associate select his/her name on the list the code ask for a password before unhide the spreadsheet. I really appreciate a help. -- regards from Brazil Thanks in advance for your feedback. Marcelo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |