I would like to be able to protect a cell and copy its calculated content to a word document currently from what I can tell is you cannot
I have created a spreadsheet to calculate phrases and numbers from America to SI and would like to protect the cells calculation and copy the result to another program or word doc. I have a poor workaround where I point to the cell that has the Calculation in column L of the attached file which is unprotect but it easy to lose the formula as you copy the result which is a pain for a person that does little with excel if there is a work around or you make this possible PLEASE! let me know at Joseph.Dyer@usda.gov We have a program the does the formatting I included the Amodac file so you could get an idea what I am doing in the excel file. It is protected with no password so have at it if your interested! Thanks joe!