my spreadsheet has cancer

T

TCT

My workbook has several pull-down "combo" boxes on one of
the sheets. Whenever I hit the "un-do" button on another
sheet within the workbook, one or more values and formats
from the pull-down boxes appears automactically (just
pastes itself) on the wrong sheet and corrupts the cell
upon which it over-writes. I can copy over the corrupted
cell, but that won't keep the circumstance from happening
again. It is difficlut to use several of the sheets now
because of this "cancer" which is spreading around.

The file is pretty big, maybe 3MB. There are several
macros and other VBA objects. This is XL 2000 / Windows
2000 Professional. This is a 2-year old workbook that we
constantly update, but this particular problem is only
about 6 months old and is getting worse.
 
F

Frank Kabel

Hi
try creating a new/fresh workbook and manually move your content and
the VBA code to this new workbook
 
T

TCT

I was afraid taht you would say that. Did you ever
expereince a similar problem?

Viel Dank
 
Top