+ Reply to Thread
Results 1 to 2 of 2

Insert & delete rows in protected worksheet: syntax

  1. #1
    Registered User
    Join Date
    08-15-2019
    Location
    Dublin, Ireland
    MS-Off Ver
    MO 365 Pro Plus
    Posts
    1

    Insert & delete rows in protected worksheet: syntax

    Hi everyone, I'm very much new to excel and to the forum so please be kind

    I found VBA code on this site from 2012 (courtesy of the user dspel79082), which solves a problem I was experiencing. I wanted to create a locked worksheet in which you can still insert and delete rows. However, I do not understand certain aspects of the code and would greatly appreciate if someone could run through each line and explain the syntax behind it.

    Please find the code below:

    Please Login or Register  to view this content.
    Last edited by sean2963; 08-15-2019 at 06:17 AM. Reason: Accordance with forum rules

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Insert & delete rows in protected worksheet: syntax

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    As you are a new member, it is possible that a moderator will make the change for you if they look at your thread.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

+ 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. how to insert and delete rows in a protected worksheet
    By marj0909 in forum Excel General
    Replies: 5
    Last Post: 06-23-2017, 03:53 AM
  2. Macro to Insert a Row and Delete Row in protected worksheet
    By dct in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2015, 05:45 AM
  3. Replies: 2
    Last Post: 04-05-2014, 03:45 PM
  4. Insert & Delete Buttons - Protected Worksheet
    By cjwescott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 04:26 PM
  5. Copy and paste insert rows with protected cells in protected worksheet
    By excel_gecko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 05:50 PM
  6. How to delete rows in a protected worksheet
    By md95065 in forum Excel General
    Replies: 7
    Last Post: 12-19-2011, 07:27 PM
  7. 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