I want to use formula in a workbook. i will have a control worksheet where i will type my workbook will have formulas or values .
if i type in control sheet range
A1 = value
my workbook should convert all formulas to value.
if i change to formula all the values should convert to what originally typed formula.
Remamber this file may also have link to other workbooks.