Formual Protection

  • Thread starter Thread starter Aversin
  • Start date Start date
A

Aversin

Is there a way to lock a formula into a cell yet still allow the user t
alter its content without erasing the formula?

ie I put an index function into a cell, but if the user wished the
could change the cell, but if they mess up the formula is gone
 
Either a cell contains a formula, which returns a value,
or a cell contains an entered value. You can't have
both.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Protection? 2
Inserting Picture Into Protected Worksheet 1
How to separate contents of one cell into multiple horizontal cell 1
Formula problems 2
protection and changing formulas 3
Excel VBA 1
#VALUE! Error 3
corrupted formula in protected worksheet 21

Back
Top