View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] idanovich@gmail.com is offline
external usenet poster
 
Posts: 4
Default show value but hide function

Hi,

I have a macro the works great and does a lot. Now I want some cells
to show the results I got but hide the functions and calculations
behind them. As of now if someone clicks on the cell they can see the
formula that was used to get the result. I was them to only see the
result and not be able to see (or change) the formula. Is there any
way to do this?

-Idan