Delete Form, Module and This Workbook code (Run Once)

Good day,
I have searched briefly and nothing to my liking. Looking for some information on the following:

I have a Userform that will send information to my Sheet that will be hidden. I will also have a "on Workbook_Open" to call this Userform. (frmopen.Show)

This userform must be deleted after the information is unloaded. Therefore the userform will be initiated on open, and once the information is inserted (commandbutton1_click in my frmopen) in my sheet, the Userform must be deleted but also the Workbook_Open / frmopen.Show.

Could someone please point me to the right direction or send me a link so I can figure this out.

Thank you,
ExcelNoub

Thank you Adyteo,
I will try to figure this out and only delete a certain (frmadmin) module and not all modules.

Excelnoub

I found a workaround here is what I have come up with and seems to work perfectly:

Code in my ThisWorkbook

Please Login or Register  to view this content.

Code in my Userform1:

Please Login or Register  to view this content.

Code in Module1,2 and 3

Please Login or Register  to view this content.

What the code is doing is... On Workbook open, loading my Userform1 so I can add information to my sheet (for info only), then deleting my "ThisWorkbook" code in its entirety, Then it will add a new code in my "ThisWorkbook" that will add to open Userform2.

Then I am calling to Delete all Modules 1 2 3. Will fine tune this code so I have everything in Module1 and I will only have to delete Module1 at the end


ExcelNoub