+ Reply to Thread
Results 1 to 3 of 3

Carry Forward of Formulas from locked cell after inserting new rows

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Guwahati
    MS-Off Ver
    Excel 2010
    Posts
    1

    Carry Forward of Formulas from locked cell after inserting new rows

    Hi,
    I am making a sheet which i want to put restriction for other users. But the problem is that when i lock the worksheet and insert a new row but, the formula from one of the cell is not carry forwarded to the new cell.
    Please some one help me for this,

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Carry Forward of Formulas from locked cell after inserting new rows

    Do you insert the row after the locking or before?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Carry Forward of Formulas from locked cell after inserting new rows

    Hi,

    Can you be a bit more explicit. e.g. what formula, what do you mean by new cell, what do you mean by carried forward?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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