+ Reply to Thread
Results 1 to 3 of 3

Excel lock value once calculated

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    bhopal
    MS-Off Ver
    ms excel -2007
    Posts
    4

    Excel lock value once calculated

    First please check all formula from range(b4:af16).
    I want to lock cell value once calculated in this range of (b4:af16) of each cell
    if i select name(g2) and path (h2) and amount (i2) then the result which outcomes in range(b4:af16) will be locked as value or not to be change.
    Please help!!
    Attached Files Attached Files
    Last edited by ady26; 06-05-2020 at 10:39 AM. Reason: NEW IN EXCEL FORUM DONT KNOW HOW TO POST

  2. #2
    Registered User
    Join Date
    06-02-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    51

    Re: Excel lock value once calculated

    You would need to do this with VBA which isnt my strong point but if you delete the formulas in Sheet 3 and assign a macro to the button and have the macro as:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    it will work... someone else can probably write the macro much better than me though

  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    bhopal
    MS-Off Ver
    ms excel -2007
    Posts
    4

    Re: Excel lock value once calculated

    macro error

+ 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. Creating calculated field and calculated item into a pivot table
    By dvpe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2019, 12:15 PM
  2. [SOLVED] how to lock selected cells lock in excel
    By koteswar in forum Excel General
    Replies: 10
    Last Post: 10-25-2018, 02:38 AM
  3. Issue with Calculated filed in Pivot Table (wrong output calculated)
    By martinrt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-18-2018, 03:11 PM
  4. [SOLVED] Lock Cell Value once Calculated
    By Laminar in forum Excel General
    Replies: 3
    Last Post: 01-20-2009, 12:52 PM
  5. [SOLVED] How to lock calculated data before a sort?
    By Sam Bede in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 09:40 PM
  6. Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  7. How can Excel vba detect if Caps Lock or Num Lock is on?
    By abc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2005, 02:20 AM

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