Results 1 to 5 of 5

Unlocked cells not available when sheet is protected.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    142

    Unlocked cells not available when sheet is protected.

    I have a little issue with my spreadsheet. It's a simple data entry with VBA coding. Including the hidden 'validation' sheet there are 2 sheets.
    There is some VBA script run on opening the spreadsheet, including freezing the top line.

    Problem is, I have the worksheet protected so that users can only enter details into selected cells. Users can only select the cells that are unlocked however users can only select down to row 5 yet when checked, cells below row 5 are not selected to be locked.

    I don't know if it has anything to do with the VBAs I'm using or if it's an issue with Excel / spreadsheet but I'm hoping someone can resolve this for me (or at least give me some idea's)

    I have attached the sheet so you can take a look for yourselves.


    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find/Replace on unlocked cells in protected sheet
    By deepu.gouwtham in forum Excel General
    Replies: 5
    Last Post: 06-12-2011, 07:34 PM
  2. how to leave some cells unlocked in protected sheet
    By shatzia in forum Excel General
    Replies: 0
    Last Post: 09-22-2010, 01:29 PM
  3. [SOLVED] allow comments, unlocked cells, protected sheet
    By Jeff Higgins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2005, 10:05 AM
  4. move between unlocked cells on protected sheet
    By ayanna in forum Excel General
    Replies: 1
    Last Post: 04-27-2005, 01:06 PM
  5. Formatting unlocked cells on protected sheet
    By Lee Schipper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2005, 03:06 PM

Tags for this Thread

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