On Jul 28, 8:34*am, "Bernard Liengme" wrote:
Sorry but No.
A formula can do one thing and one thing only: it can return a value
If you have a formula in a cell and you type something else in that cell and
press Enter then the formula has gone.

To get this to work: "if A1 = 500, then B1:B10 would be protected" you would
need to use VBA code
best wishes

--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

"John Sofillas" wrote in message

...



Hi,
I was wondering if there was a way to write an IF formula that results
a range of cells to be protected? In other words, if A1 = 500, then
B1:B10 would be protected? I also heard there may be a way to format a
cell to where you could have a formula in, yet still be able to key
punch in it, without having to erase the formula in the cell. This too
would satisfy my needs. Any truth to it? If someone could answer
either of my inquiries, I would appreciate it. Thanks!- Hide quoted text -

- Show quoted text -

I was affraid of this. What is VBA code?