I have a code that builds about 200 workbooks based on a list that is on the parent Workbook. Because this takes about 30 minutes, I want the user to be able to continue to do work (with all code activity done in the background).
Making the Parent workbook invisible was easy, but I am unable to find how to create new workbooks without them popping up as visible. Here is the current code snippet:
I do not seem to have the option to tell it to create the workbook as Visible = False. I can hide it after its created but that does not accomplish the goal.