+ Reply to Thread
Results 1 to 3 of 3

Add/delete table rows on protected worksheet

  1. #1
    Registered User
    Join Date
    04-04-2018
    Location
    Glasgow, Scotland
    MS-Off Ver
    MS 365
    Posts
    34

    Add/delete table rows on protected worksheet

    I have a spreadsheet with many columns, only two of which should be available for the user to enter data. The data is arranged as a table whose length can vary, from one or two rows to thousands. Initially there is only one empty row containing the formulae. I have applied worksheet protection, allowing access to unlocked cells and the addition or deletion of rows. I find that with worksheet protection switched on I cannot add or delete rows. I could write code to add a row but before I do that I'd like to know if there is any way to configure the table so that rows can be added in the normal manner (ideally just by starting to type in the next row) even when protection is switched on.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Add/delete table rows on protected worksheet

    I think allowing rows to be added would defeat the purpose of protecting the sheet, so my answer would be no. But I have answered these things logically before and have been wrong.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Registered User
    Join Date
    04-04-2018
    Location
    Glasgow, Scotland
    MS-Off Ver
    MS 365
    Posts
    34

    Re: Add/delete table rows on protected worksheet

    Seems to be a bug/undesirable feature of Excel. It seems many requests have been raised om Microsoft to allow adding/deleting rows on protected sheets.

+ 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. Can not delete rows on protected worksheet
    By wwestlin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2018, 08:59 AM
  2. How to delete rows in a protected worksheet
    By md95065 in forum Excel General
    Replies: 7
    Last Post: 12-19-2011, 07:27 PM
  3. In a protected worksheet allow users to delete rows
    By Jason Trivett in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. In a protected worksheet allow users to delete rows
    By Ian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] In a protected worksheet allow users to delete rows
    By Jason Trivett in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] In a protected worksheet allow users to delete rows
    By Jason Trivett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2005, 05:05 AM
  7. [SOLVED] How do I delete rows from a protected worksheet?
    By Dan T in forum Excel General
    Replies: 4
    Last Post: 07-08-2005, 04:05 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