I see this behaviour if I have added a userform or any of the normal control
to a worksheet and then deleted all of those objects.
Even after saving, closing and re-opening.
May be Rob's Code Cleaner will help:
http://www.appspro.com/Utilities/CodeCleaner.htm
However, why is this a problem ?
If no userforms or controls have ever been added, this reference is not
checked.
NickHK
wrote in message
ups.com...
1. Enter Excel workbook VBA code modules.
2. Select Tools References, and it shows that "Microsoft Forms 2.0
Object Library" is checked.
3. Now, it's unable to uncheck "Microsoft Forms 2.0 Object Library".
4. Why ? Since it shows that "Can't remove control or reference ; in
use".
5. However, go to Worksheet ; Select Edit GoTo Special Objects ;
and there, it shows that "Objects not found".
6. The requirement is to uncheck the reference to Forms Object Library
so that the code modules could be run in order.
7. But, How to uncheck the Forms Object Library ?
8. Please share your experience. Regards.