Results 1 to 2 of 2

Thread: Allow editing but no deletion of formula in column

  1. #1

    Allow editing but no deletion of formula in column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a column E that i am calculating based on another column values so it has some default values and formula in it initially but i am want to make this column editable by making user enter their own values but i dont want to delete the formula.


    Asking this-
    Leave the formula in your cell
    if the user selects the cell the formula disappears
    the user types a value or not, up to them
    the user selects another cell
    if the cell is empty the formula re-appears






    I have range E15:E74 having formula that i want to allow editing as well if selected otherwise leave it default formula.
    E15 :E29 has one formula and E30:E74 have same formula.
    Please help .

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,779
    Articles
    0
    Excel Version
    365
    cross post http://www.mrexcel.com/forum/excel-q...ult-value.html
    sandy, please read and act on this http://www.excelguru.ca/content.php?184 , at all other sites you have cross posted in:
    Then I will try and answer your question.
    Last edited by p45cal; 2015-07-11 at 11:10 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •