Substituting numbers

[Guest]

I have a large workbook with several worksheets. Recently I found a column on
each sheet had the same series of numbers inserted. The cells where the
numbers were inserted were a combination of blankcells, linked cells and
cells with formulas. The only consistency was the range and actual numbers.
After linking another different worksheet, I have found the same series of
numbers however this time in a different column.

After correcting the numbers, the sheets remained correct for a few days and
then the problem reoccured. I have spoken to McAfee who say that this does
not sound like a macro virus but possible a corrupt template. Has anyone else
struck this type of issue before? Any help would be appreciated.

 

[tony h]

Sounds like someone has entered data (manually or programatically) with
multiple sheets selected.

If you select several sheets the changes you make apply to all the
selected sheets.

regards

 

[Guest]

Thanks Tony for the response. The issue with this is that noone on the team
that works with these sheets knows what or where these numbers have come
from. The numbers are absolute and so there is no way to ascertain where they
came in from. Any thoughts?

 

[hog.badger]

Thanks Tony for the response. The issue with this is that noone on the team
that works with these sheets knows what or where these numbers have come
from. The numbers are absolute and so there is no way to ascertain where they
came in from. Any thoughts?

Sorry, that is a puzzle indeed.
Maybe you could get to the source of it if you noticed it as soon as it
happned. If the whole column is changed then how about implementing a
checksum row with just ones in each cell and conditional formatting
that turns, say, the heading rows, red if the checksum row doesn't add
up right.

 

[tony h]

not really.

I would be tempted to put some code into events such as workbook open
and close events to check for the values not being as expected. with an
alert eg msgbox to let the user know what has happened and then narrow
down what has happened to a particular event

regards