Delete Empty Worksheet Modules

I would like to delete all the empty worksheet modules for the active workbook instead of removing these one by one

it would be appreciated if someone could assist me

As a worksheet module can only be deleted by deleting the worksheet itself …

In the previous post 'Module1' can't be obviously a worksheet module …

Thanks Marc

module1 is the main module, but by using the macro recorder one could end up with several modules that one no longer requires but one needs to delete these manually one by one

Thanks mickerickson for the code

I need to remove all blank modules for the activeworkbook, except module1

Originally Posted by Howardc1001

but by using the macro recorder

So it can not be a worksheet module as you wrote 'cause the Macro Recorder uses only regular modules …

thanks guys

The modules appear as

Hi xladept


Thanks , your code works perfectly