EXCEL: ThisWorkbook.Save Not Working While Deleting All VBA Codes

**[email protected]** · 05-14-2013, 06:38 AM

Dear All

In my Excel file I' am having many Modules, Sheet Level Code & Workbook Level Codes.

I' am using on CommandButton calling a module which is Clearing all the Codes from Sheet, WorkBook, Modules and also Deleting Modules.

I' want to auto save the file with "ThisWorkbook.Save" once all the codes and module is deleted.

As there are chances that user will not save the file after running this module, which is causing the code to remain in file.

This is what not working and I' am not able to save the file Automatically.

Code is working properly, just not able to AUTO SAVE the file.

Please help me on this.

I' AM USING BELOW MODULE TO DELETE CODES.

Please Login or Register  to view this content.

Thanks
MG

**nathansav** · 05-14-2013, 07:27 AM

Is it deleting this routine which is causing it?

**[email protected]** · 05-14-2013, 08:48 AM

Yeah!

But if it is running till the End Sub

If I' put MsgBox instead of ThisWorkbook.Save

I' am able to get the message.

But I' don't know why it is not saving the file.