Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Password Protect Cells (2003)

    We have a departmental statusd sheet on a shared corporate drive in which all departmental employees (6) are to update their status on projects. Each employee has a dedicated column where his projects are to be updated. What I would like to do is password protect each employees' columnso that only he may have enter data in it. Any ideas?
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password Protect Cells (2003)

    Excel doesn't have password protection at the level of cell ranges. You might do the following:
    - Initially, keep all cells locked, and protect the worksheet with a password.
    - In the Workbook_Open event procedure (in the ThisWorkbook module):
    - Check the login name Environ("username")
    - Unprotect the worksheet, providing the password.
    - Unlock the cells in the column that the login user is allowed to edit.
    - Protect the worksheet again, providing the password.
    - In the Workbook_BeforeSave event:
    - Unprotect the worksheet, providing the password.
    - Lock all cells.
    - Protect the worksheet again, providing the password.
    - Lock the VBA project for viewing, using a password.

    If a user disables macros when opening the workbook, all cells in the sheet will be locked. If macros are enabled, only the relevant column will be unlocked.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Password Protect Cells (2003)

    If you are on a domain you can allow specific users to edit specific ranges. Tools->Protection->Allow users to edit ranges.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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