On Apr 25, 5:09 pm, "Peter T" <peter_t@discussions wrote:

6. The requirement is to uncheck the reference to Forms Object Library
so that the code modules could be run in order.

Interesting, why?

Regards,
Peter T
__________________________________________________ ____________________

replies :-

The affected code modules could be copied to a new workbook ; and
there, the code runs "flawlessly". Upon examination, Tools
References, Microsoft Forms 2.0 Object Library is not checked in the
new workbook.

When the code is run in the original workbook, it causes an error,
"Type Mismatch". The error does not recur when the code is run in the
new workbook.

If there's a simple way to uncheck the Forms Object Library in the
original workbook, it would save deploying a new workbook.

The "check" has resulted from Chart plotting in the original workbook,
I think. And then, all the charts are deleted ; and there, unable to
uncheck the Forms Object Library (as much as I could repeat saying
once more over again).

Regards.