Results 1 to 4 of 4

How to password protect only certain cells within a sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-09-2014
    Location
    Lauder, Scotland
    MS-Off Ver
    Windows 8.1
    Posts
    160

    How to password protect only certain cells within a sheet

    Hi,

    I am creating a spreadsheet for teachers to use to track the levels that children are achieving for different curricular areas.

    Within the sheet titled 'Maths Detailed' is there a way that I can lock the cells so that only the P1 teacher can change the cells for P1 and only the P2 teacher can change the cells for P2 etc.

    I'm thinking each teacher would have a password to access their cells but do not know if this is possible? I am aware that I can password protect the whole sheet but not sure if I can password protect individual cells?

    Any ideas?
    Last edited by kevwilsondj; 03-23-2015 at 07:43 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Protect a sheet with a password, but secure the password
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2013, 01:59 AM
  2. Excel 2007 : VBA - Password Protect Sheet / certain cells
    By littlefoot in forum Excel General
    Replies: 2
    Last Post: 12-13-2011, 01:43 PM
  3. Password protect a sheet
    By Wade LEES in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2009, 08:33 AM
  4. Protect Sheet & Password Protect Code
    By KLahvic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2009, 04:08 PM
  5. Password protect 1 sheet
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2008, 11:08 AM

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