Formulas deleted when calculating sheet

[ed.ayers315]

Hi Forum goers,

I have a worksheet with a form, anytime I remove the manual calculation and change to automatic, the formulas in my worksheet disapear.

The userform does not have any of the activesheet cells referenced that has formulas.

Why is this happening? And, is there a workaround beyond staying in manual calculation?

Thanks for any help

 

[VoG]

What exactly is your code?

 

[ed.ayers315]

Hi VoG,

Good to hear from you again.

Not following what you mean by code. Just formulas like <=B16-(B27*$P17)> None of these cells are located on my form but are overwritten with the result evertime I switch back to automatc calculation. If I stay in manual it is ok, I would rather be in automatic.

 

[VoG]

If you have code that is writing values to these cells then the formulas will be overwritten. Other than that, I am as puzzled as you are.

 

[ed.ayers315]

No written code; is there soemthing associated with the form that I do not know that could be doing this?

Here is the only code with the form.

What happened to the Code tags in the tool bar?

<<Private Sub CLOSE_CSR_AUDIT_1_Click()
ActiveSheet.Protect
ActiveSheet.Calculate
CSR_AUDIT_1.Hide
End Sub
Private Sub GOTO_NEXT_AUDIT_2_Click()
ActiveSheet.Protect
CSR_AUDIT_1.Hide
Sheets("audit_uf_mf_df").Select
ActiveSheet.Protect
CSR_AUDIT_2.Show
ActiveSheet.Calculate
End Sub>>

 

[VoG]

I cannot see why your formulas are being overwritten.

For code tags

[code]
code here
[/code]

 

[ed.ayers315]

VoG, thanks for taking your time