View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Excel VBA Reference to Forms Object Library (to be unchecked)

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.