+ Reply to Thread
Results 1 to 2 of 2

lock specific cells in table but allow user to add rows

Hybrid View

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    St. Paul, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    28

    lock specific cells in table but allow user to add rows

    Hi all

    I'm trying to create some code that will allow a specific table range to be locked so that users cannot change necessary formulas, but I also need the add row function to be available.

    Everywhere I've looked seems to say that this can't be done, unless code is created that lock the cells until the user adds a row, at which time the code would unlock the cells, add the row, and the lock the cells again.

    Anyone have ideas how to make this work?

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,027

    Re: lock specific cells in table but allow user to add rows

    Lock the desired range. Protect the worksheet. In the menu that pops up when you protect the sheet, you can choose which functions to allow. Click "Insert Rows" and then click "OK".
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lock specific rows with a drop down box
    By ecraw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 01:08 PM
  2. Lock specific cells
    By PerdixDaedalus in forum Excel General
    Replies: 2
    Last Post: 01-12-2013, 10:44 AM
  3. Cells lock after user input - based on data
    By francis.rizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 09:55 AM
  4. Lock/Unlock Cells Based on User Type
    By jzeusj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2011, 04:01 AM
  5. Protect/lock cells after user input
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2009, 08:46 PM
  6. Lock specific rows while inserting new rows
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2008, 10:00 AM
  7. Can't lock specific cells.
    By manoa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2007, 12:37 PM

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