+ Reply to Thread
Results 1 to 3 of 3

Insert Row and copy formula in protected sheet

  1. #1
    Registered User
    Join Date
    04-25-2016
    Location
    miami, fl
    MS-Off Ver
    2010
    Posts
    2

    Insert Row and copy formula in protected sheet

    I have a table in columns A-G and with hidden columns H,I. columns F-I have formulas that are protected.

    I'm looking to be able to add rows in my table while the worksheet is protected and when doing so be able to copy the formulas from the previous row. I have read and tried some macro's but none of them have worked.
    Last edited by cangel2; 04-26-2016 at 09:20 AM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Insert Row and copy formula in protected sheet

    Hi cangel,

    Welcome to the Forum!

    Do you mean columns?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-25-2016
    Location
    miami, fl
    MS-Off Ver
    2010
    Posts
    2

    Re: Insert Row and copy formula in protected sheet

    yes sorry - i edited the post to say columns lol - thanks!

+ 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] Insert row and copy formula in protected sheet
    By impresxy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2017, 02:57 AM
  2. Macro to copy and insert down several rows in protected sheet
    By Sardokar21 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-28-2015, 03:15 AM
  3. Insert Row and Copy Formula from Row Above (Protected and Shared Workbook)
    By egarla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2014, 08:46 AM
  4. Replies: 3
    Last Post: 07-26-2014, 06:12 AM
  5. Insert Row on Protected Sheet and Auto Copy Formulas
    By ltradey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2014, 05:46 AM
  6. Replies: 1
    Last Post: 03-29-2014, 09:56 AM
  7. Insert row and then copy above formula on protected sheet
    By Rinto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 02:45 AM

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