This sounds simple enough, but after a few hours have yet to find a solution.
lets say in code I reopen the same workbook with something like:
Now on reopening I would like to run some more code, perhaps a form, how can I achieve this.
I have tried, without success:
they all work fine when opening the workbook manually, but stop working if opened in code.
any solutions would be appreciated. I would prefer not to have to create a dummy workbook.