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,
Bookmarks