Looking for information on the following:
spreadsheet with VBA macros and active-x objects fails on save or open. File
repair always shows Lost Visual Basic project and Lost ActiveX controls which
of course losed all the macros and makes the worksheet unusable.

happens most often when macro changed, but does not happen on every change.

Have base (unfailing version of worksheet) copy it and make VBA macro
change. Save change copy. My fail on save, may fail on next open, may not
fail at all or until another VBA macro change is made. Have rebuilt workbook
and active-x object from scratch and imported Module and classes. Seemed to
have resolved issue until recent change.

Sure could use some help with this.