Excel question
Hey guys, i'm currently working on a log in excel for 3 people. In this log it will indicate when they begin and finish work on projects also there wil be a column for comments. There are 3 columns for comments, 1 for each user, and these comments are mostly constructive critism to help them in future projects.
Now all of this log is in 1 worksheet and I would like to hide each comment column so that other users can not view others comments. Is it possible to password protect and hide each of the 3 column with a separate password so that only the intended viewer will have acesss to the comments?
I would like the password to disable the hide feature for the column so that they can view the comments. Also I would like the hidden column to be protected from editing from everyone except me.
Is this doable with excels built-in password protect feature? Or do I have to go the macro route? If I do have to write a macro can anyone point me to some references on how this can be done.
Thanks guys!
Bookmarks