T
TUNGANA KURMA RAJU
I am facing a unique problem in hiding the cells that have formulas.
I have w/book in which 5 cells(K2:K6) of every sheet has formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulas>format >Cells>protection>Checked
Hidden option>ok.Next from Tools Menu>Protection>Protect sheet>Protect
w/sheet and contents of locked cell>allow users to> select locked
cells&select unlocked cells>ok
I have w/book in which 5 cells(K2:K6) of every sheet has formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulas>format >Cells>protection>Checked
Hidden option>ok.Next from Tools Menu>Protection>Protect sheet>Protect
w/sheet and contents of locked cell>allow users to> select locked
cells&select unlocked cells>ok