Blocking fields to avoid use in formulas

P

Piotr

Is there any possibility to block the particular field in order to
avoid users to use invalid fields in formulas ?

regards
Peter
 
D

Dave Peterson

You can lock and unlock cells (then protect the worksheet) so that users can't
change certain cells.

But if you allow them to type a formula into a cell, then I can't think of
anyway of stopping them from pointing at A1 when A1 shouldn't be used.

Is that what you meant?

If it is, maybe someone else has a way...

If it's not, maybe you should rephrase your question.
 
P

Piotr

Yes thats what I ment

I wish to stop the user from select, for example A1 in formula becouse
it shouldn't be used in formulas.
 
Top