Compile a Value in VBA Instead of Cell

Mudraker,

I did have a lot of formulas running in several different cells that calculated information that I needed for other displayed cells. Most of the cells containing the formulas do not need to be displayed for the end-user of the worksheet. I initially highlighted all of the cells that contained the formulas that I did not want visible and changed the font color to white so that they would not be displayed. However, this seemed a little cheesy to me and, if the cells were highlighted, would become visible.

Is there a simple way to hide several formulas that will run in real-time in the worksheet that will not be made visible to the end-user? The reason I went the VBA route was because of this....

Thanks!

You can protect the cells, hide their contents, and protect the workbook - then users will not be able to see the formulas. Nothing you've said so far warrants the use of VBA.

If you just want to because you want to, that's fine.