XL2000: How to Delete a Collection of Code Objects from a VBAProject (260993)
The information in this article applies to:
This article was previously published under Q260993 SUMMARY
This article contains a sample Microsoft Visual Basic for Applications macro to loop through all the objects in a VBProject, and remove the objects contained in a specific collection. For example, you can remove all standard module sheets in either the active workbook or a specific workbook.
REFERENCESFor more information about VBE objects and properties, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type VBE Property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto KB260993 |
---|
|