MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro deleted by itself or another macro

Posted by Ed J. on September 21, 2000 10:27 AM

I've wriiten a macro to create and save mutiple workbooks. The problem is that these workbooks and their sheets are protected with passwords that are in the macro. I'd like to automatically delete the macro that has just created the workbook. Since I don't think it can delete itself, can I make another macro to delete the first?

Posted by Celia on September 21, 2000 5:12 PM


With ThisWorkbook.VBProject.VBComponents
.Remove .Item("Module1")
End With