#value error

[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.

 

[JE McGimpsey]

It's almost impossible to guess what solution would be appropriate when
you haven't told us what functions you have in column C...

 

[swtupr]

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.