I have QC checklist with a cell at the bottom for the user's initials. We have 8 users, and I would like to create a way that each user can enter their pin and have their initials come up in the cell. Ideally, there would be no way to the other users to know each other's pins or find out in the spreadsheet. Do you think it is do-able using VBA and does anyone have any tips on how they would approach this? All comments are most appreciated!
Hi there,
You can:
- protect the worksheet with password (except the cells someone is doing something in them)
- write LogIn procedure to workbook_open event an write all PINs in to that procedure. When someone enter a PIN and PIN match authorization requirements, You can with VBA unprotect sheet->write that PIN to cell You want->protect again, so noone can rewrite it.
- protect VBAProject with password (no one except the one who know that password, will see PIN numbers)
This is how You can do it...
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks