Have a look here but note the cautionary remark that this is not very secu-

http://www.j-walk.com/ss/excel/usertips/tip060.htm

Mike

"oaallam" wrote:

I have a big number of large excel files, each file of them has a number of
worksheets. The values appearing in the cells of each worksheet are mostly
the results of formulae or functions entered into the formula bar. When you
click on one of these cells the formula or function that has been used
appears in the formula bar.
I want to make copies of these files in which, when a cell is clicked on,
the numerical value of that cell, not the formula or function that has been
used, will appear on the formula bar. This is because I need to give these
copied files to somebody and I do not want to him to have knowledge of the
formulae and functions used in the computations .
I tried copying the files using the copy and the "column width, format and
value" alternatives of the special paste method in succession, for each work
sheet seperately, but found it very tedious due to the big numbers of files
and worksheets.
I hope there is a simpler way. I will appreciate your help