Hello! I have a project that I am working on and would love a hand making work better.
I have created a workbook that opens a UserForm on file open then performs tasks 100% via the user form. I have hidden the Excel Window however I found a downfall to this. I find many end users of this User Tool have several Excel files open already. Since I either hide the workbook via
vb code and go modeless to make the end user view the tool more as a program.
Is the a
vb code that I could use before calling my user form to open a new Excel Window (other than the one already open)?
Thanks in advance for the help!