RE: I have Some Sort of Macro/Worksheet Corruption Problem :-(

Tech-Archive recommends: Speed Up your PC by fixing your registry

I was hoping you would solve the problem and let us know what the cause was.
Your description sounded like a possible mouse-over call, or possibly an
induced work*** change procedure, but I wouldn't know how to tell you where
to start looking, except everywhere code can be entered. Macros don't just
run of their own accord. They have to be triggered by some event, whether by
keystroke, mouse or change of a value.

"dim" wrote:

Hi folks,

I still don't know what caused this, but would like to for future reference
if possible?

...but I've managed to remove the problem by re-creating the relevant
worksheets, and deleteing the originals, then re-naming the recreated ones
with the name of the original.

I didn't copy/paste the entire original work*** across to the new one
because this reproduced the problem, instead I only selected the rows I
needed and copied/pasted these across. For some reason this worked. Its a
pain having to resize all the columns, but luckily I noticed this now, and
only have to redo 6 out of an eventual 78 worksheets.
.

Quantcast