Generate a "Workbook Open" Macro in new worksheet Programmaticly

Hello, I have searched to find the answer myself but I just can't seem to find what I am looking for. I have a LARGE Workbook that I call a "Program" because it has lots of Userforms that I use to enter data in and then at the end it generates a new Workbook based on what I typed in all without the user ever even seeing an excel workbook,worksheet, or cell.
One of the worksheets generated in this new workbook is what i call the "CONFIG" sheet and I use as a "CONFIG" file so that at a later date I can use the new workbook to re-load all that data back into my "Program" so I can generate a different workbook with it and not have to type all that data back in.....I hope that made sense..anyway all i need is a way to add a

Public Sub Workbook_Open()
Sheets("CONFIG").Visible = false
end sub

to the new workbook automatically when the Macro generates it the first time. So that the user of the new workbook does not see it. If you have any questions let me know.
Thank you for your time,

Is there a reason you can't simply hide it when you create it? If there is, I would suggest using a template workbook with the code already in it (I am not a fan of writing code in code unless absolutely necessary).

Is there a reason you can't simply hide it when you create it? If there is, I would suggest using a template workbook with the code already in it (I am not a fan of writing code in code unless absolutely necessary).

You know, that was my first thought as well so I tried Using that same line

Sheets("CONFIG").Visible=False

Immediately after creating the new sheet, but it didn't work. Next time I opened the new workbook the CONFIG sheet was visible.

I would suggest using a template workbook with the code already in it

I tried this as well, I added the Workbook_Open code from above to my template file that I use and it didn't seem to do anything. --edit-- after modifying the template like you suggested when I manually insert the template it asks if I want to allow Macros, but then if I go to the VBA editor and look there is no Workbook_Open code in the new workbook, with the new worksheet I just inserted from the template..

Good afternoon TheNewGuy

Try using this code :

Sub test()
Set wbcodemod = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.CodeName).CodeModule
Set codemod = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.CodeName).CodeModule
codemod.insertLines 1, "Public Sub Workbook_Open()"
codemod.insertLines 2, "Sheets(" & Chr(34) & "CONFIG" & Chr(34) & ").Visible = False"
codemod.insertLines 3, "End Sub"
End Sub

Before you run it set a reference within the VBE to Microsoft Forms 2.0.
Go to Tools > References, find and tck "Microsoft Forms 2.0 Object Library" and click OK.

HTH

DominicB

You would need to use a template Workbook, not worksheet.
If you try to hide the sheet in code when you create it, you should do two things:
1. Specify which workbook you are manipulating:

Workbooks("new workbook name.xls").Sheets("CONFIG").Visible = xlSheetVeryHidden

2. Make sure you save the workbook afterwards!