Hi everyone,
Im having a hard time with this and I really expect you to help me please.
I have a form with a button, that button shows another form with another button, without hiding the previous form. Everything works fine so far. So in the second form, i've got the button so when you click it, it creates a new workbook. I've got the application to be hidden, this means that when you run the application, it opens just the forms, you can't see the worksheets nor the workbook.
When I click on the button to create a new workbook, it creates the new workbook BUT it takes "control" of the application. This means that if I want to close this new created workbook, the application closes too. I don't want this to happen.
Here's the code of the button:
BUUUUUUUUUUUUUUUUUUUUT if I make visible the application (make workbook appear changing Application.Visible = True), it works fine, if I close the new workbook, the application doesnt close. That's what I need,
I NEED TO OPEN THE APPLICATION WITHOUT SHOWING THE APP'S WORKBOOK, CREATE A NEW WORKBOOK, BEING CAPABLE TO SAVE OR DO WHATEVER I WANT WITH THIS NEW WORKBOOK (EVEN CLOSING IT) WITHOUT HARMING THE APPLICATION.
Things to make clear:
- ShowModal on both formularies are FALSE
- Im not hiding the first form
- When I create the workbook, I want to close that second form that creates the workbook and return to the first one automatically
I'm expecting to have other option rather than always showing the workbook of the app, that wouldn't be aesthetic.
Thanks for your help
Bookmarks