It sounds like there is some hidden corruption in the
file. Recovery from this type of problem can painful. The
only thing I can think of is the following:
In the VBA editor export everything (sheets, macros,
forms, class files, etc.)in the workbook to a class file
except the macro that is a problem. If the macro is a
sheet or form macro do not export that item. You can
export each item by selecting each sheet, form, etc. and
then right click and select export. When you have exported
everything but the problem macro, close this file. Open a
new file and import everything you have exported from the
previous file. Recreate the sheet, form or macro that
contained the previous error.
This may be painful to do, but it is the only thing I know
that should work. I have done a fair amount of development
in Access and would have corruption problems from time to
time and something similar in Access was the only solution.
If this is to painful, unless this macro is causing
problem it may be better just to leave the problem macro
there and ignore the problem. I hope that helps!
Kevin
