+ Reply to Thread
Results 1 to 2 of 2

Thread: Insert Data but Edit and Delete is not allowed (Protected)

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    147

    Question Insert Data but Edit and Delete is not allowed (Protected)

    Aim/ Object — I want to protect the columns C, D, E & F of the different Subjects in the table. I would like to allow the others to just insert the data in these selected cells, but the another point no-one is allowed to edit or delete the data of any cell.

    This is how the users can insert their data/ information in the cells (C5:F50), but they need a password to edit or delete the values of the cells.

    Can this be possible? I saw this trick in someone's workbook. It's very important for my project.

    Note - I have to keep this workbook as shared at the shared drive.
    - I use MS Office 2003.

    Thanks in advance!
    SunOffice
    Attached Files Attached Files
    Last edited by SunOffice; 10-14-2010 at 10:51 PM.

  2. #2
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    147

    Re: Insert Data but Edit and Delete is not allowed (Protected)

    Can I have any solution of this post.... plz?? I need this.

+ 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.2.0