Hidding Fomula

[ziad alsayed]

dear all

it is possible to hide a cell formula without protecting a Sheet.

appreciate any help

 

[MrKowz]

Potentially you could create a worksheet_change event on a particular cell and have VBA perform the calculation, and store the answer in a different cell.

Or, alternatively, you can hide the column/row the formula is on.

Otherwise, no, you cannot "hide" a formula.

 

[ziad alsayed]

thanks MrKowz .