I want to clear cells D1
6 of the numeric values, but also keep the formula of those cells so the user can start over in case he/she makes a mistake or changes his/her mind regarding whether the cells D16 have items or not. Is there a way to clear the values in the cells but maintain the formula? The user must first choose cell E29 which is a drop down menu and choose whether cells D16 will have an item (data) there or be blank ("NO 20' item").
Here is the formula in the cells D16
=IF(E29="20' Item","",IF(E29="NO 20'","NO 20' Item"))
E29 is a drop down menu
If E29 = 20' Item then cell D6 is blank and a numeric value can be placed in the cell.
If E29 = NO 20' then cell D6 shows "NO 20' Item"
Worksheet is protected from user with certain cells unlocked (D16). If user chooses to have items in D16 and inputs a value in the cells the formula is deleted. What VBA code do I need to keep the formula from being deleted but allowing the user to place values in the cells? and be able to choose the drop down menu and start over if necessary (initial condition when worksheet is opened)?
6 of the numeric values, but also keep the formula of those cells so the user can start over in case he/she makes a mistake or changes his/her mind regarding whether the cells D16 have items or not. Is there a way to clear the values in the cells but maintain the formula? The user must first choose cell E29 which is a drop down menu and choose whether cells D16 will have an item (data) there or be blank ("NO 20' item").Here is the formula in the cells D1
6=IF(E29="20' Item","",IF(E29="NO 20'","NO 20' Item"))
E29 is a drop down menu
If E29 = 20' Item then cell D6 is blank and a numeric value can be placed in the cell.
If E29 = NO 20' then cell D6 shows "NO 20' Item"
Worksheet is protected from user with certain cells unlocked (D1
6). If user chooses to have items in D16 and inputs a value in the cells the formula is deleted. What VBA code do I need to keep the formula from being deleted but allowing the user to place values in the cells? and be able to choose the drop down menu and start over if necessary (initial condition when worksheet is opened)?