#value error

  • Thread starter Thread starter swtupr
  • Start date Start date
S

swtupr

Hi,
I have an excel sheet with lots of formulae in it. The value in column C
will change when the value in Column A changes (Col C has the formula). I
dont want the user to edit Col C and so i have locked C and protected the
sheet. But the user can edit Col A. When Col A is changed i am unprotecting
the sheet, calculating Col C formula(Might also insert new rows based on Col
A) and then again protecting it ( all through code) .But sometimes this code
gives me #Value error in Col C when Col A changes. Any solution for this?

Thanks.
 
It's almost impossible to guess what solution would be appropriate when
you haven't told us what functions you have in column C...
 
Hi,
Thanks for your reply.
This is just an example i have told you about col A and col C. I actually
have a lot of code behind. My major point of interest is protecting and
unprotecting the sheets while running these functions. If i dont protect the
sheet all the formulae are running fine so its not a problem with the
formulae i have but those formulae not getting calculated when i try to
unprotect the sheet at the beginning of function and protect it again at end
of the function.

Thanks.
 
Back
Top