+ Reply to Thread
Results 1 to 2 of 2

Password protecting & hiding columns

Hybrid View

  1. #1
    Registered User
    Join Date
    11-28-2006
    Posts
    6

    Password protecting & hiding columns

    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!

  2. #2
    Forum Contributor
    Join Date
    07-05-2006
    Location
    Canada
    MS-Off Ver
    2003, 2007
    Posts
    581
    The macro route is how you'll have to go, but Excel worksheet security .... is easily bypassed if you know how/want to.

    I'm not sure how easy it is to bypass the workbook security -- never had need to know.

    Someone else may be able to give you more constructive feedback.

    Scott

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1