Right-click the tab of the problematic sheet. Click View Code. Do you see
and code in the window that opens? Does it belong there???

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

I suspect that you have an event macro operating "undercover".

Because the macro may be in the worksheet or workbook area instead of a
standard module, people tend to forget they are there.
--
Gary''s Student - gsnu200909


"Luis Cortes" wrote:

Hello,

I have a problem in Excel, I've basically done alot of forms and text but after a while I realised, when I changed the value, the formula which uses that cell in it's formula replaces the cell's formula with the actual value.

For Example:

A1= B2+B3
B2= 5
B3= 6

If I chaneg B2 and B3 to 7 and 7

A1 Changes to 14, and removes B2+B3 from it's formula.

At first I thoguht it was a macro that I made, and when I open the workbook again and disable macros, it all works fine, but when I enable macros and delete the macro. It still happens?

Any idea as to why this is happening? I haven't changed any settings or anything.


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx
.