I have a spreadsheet that many people are using. We are having a problem that
people are modifying information that they aren't authorized to. I would like
to know if I can set each column (or a group of columns) so that you need to
have the password to be able to modify the information in that column. I have
about 10 different users, and therefore I would like to be able to have 10
different passwords for the desired groups of columns. Any help with this
would be GREATLY appreciated.
Password protection isn't available for this. You could try to use event
handlers displaying input boxes, but it'd be a royal PITA for your users. A much
better idea, if your users are on a network, would be finding the fOSUserName
function in the Google Groups archives for *excel* newsgroups, and calling it
from the Workbook_Open event handler to store each user's network login ID in a
workbook-level defined name, then use the SheetSelectionChange event handler to
unprotect/protect cells dynamically as they're selected based on a table of
network login IDs and corresponding ranges that the user may modify.
If you have no idea what any of this means, this may not be a practical
solution. Simpler to give each different user a separate workbook for their own
entries, then collect the workbooks after entries have been completed and
compile them into a fully protected summary workbook that none of these users
could modify (well, not as long as they're pretty honest/unsophisticated users).
