+ Reply to Thread
Results 1 to 4 of 4

Deleting rows in protected worksheet, then adding new rows

  1. #1
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Deleting rows in protected worksheet, then adding new rows

    I have two codes, one for adding rows in a locked spreadsheet.
    The problem I have is that when I have deleted rows with the second VBA Code, I am not able to use the first code to add new rows. Nothing happens when I try.

    Here are my two codes:

    Adding row (with "On Error Resume Next" because of error 1004, where you write the number of wanted rows in cell A10 and it will copy first row and insert where mouse pointer is

    Please Login or Register  to view this content.
    This code is for deleting rows in locked cells


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Deleting rows in protected worksheet, then adding new rows

    Hi there,

    Try using:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Deleting rows in protected worksheet, then adding new rows

    Hello,

    Tried it a few hours ago and it worked great!
    Now I have another problem a step further on, how to combine dialogue boxes and adding copies of rows
    http://www.excelforum.com/showthread...=1#post4339464

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Deleting rows in protected worksheet, then adding new rows

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated

    I've posted a reply in your latest thread.

    Best regards,

    Greg M

+ 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. Replies: 0
    Last Post: 12-08-2015, 08:09 PM
  2. [SOLVED] Editing recorded macro for deleting rows in a protected sheet
    By nadeem77 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2014, 08:16 AM
  3. [SOLVED] Adding & Deleting Rows in Worksheet while maintaining Formulas
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-27-2014, 07:22 AM
  4. 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
  5. Adding rows from external workbook and deleting rows from current workbook.
    By Ducatisto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2010, 10:17 AM
  6. Adding Rows ina protected worksheet for entry
    By vishusecl in forum Excel General
    Replies: 1
    Last Post: 02-13-2010, 08:25 AM
  7. Help !!! Deleting rows in protected document ?!?
    By Beisaikong in forum Excel General
    Replies: 4
    Last Post: 04-26-2005, 02:06 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