G
Gunnar
Hi there.
I have a template with the userform frmMain.
On this frmMain I have several buttons that creates and opens new documents
based on different templates.
When I have created a new document, filled it with the desired text and
saved it, I close it.
But when this document is closed, my frmMain is NOT visible. Only the
template containing my frmMain is showing, but the frmMain is not visible.
The reason is probably that I have the code frmMain.Hide in the code that
fills out my new document with text.
But this was neccesary, or else the frmMain was placed in front of my newly
created document.
I had to close the frmMain to get to my newly created document so I could
edit it some and then save/close it.
I don't want to close my frmMain until I'm all finished with all my new
documents.
The frmMain contains a lot of textboxes the the user fills out and all this
text goes into some bookmarks on the different documents.
So I have to have access to my frmMain after closing my newly created
documents.
I have figured out that VBA doesn't support the use of modal and modeless on
the forms.
Is there any other way to switch focus between documents/userforms??
Hope this makes any sense.
Gunnar
I have a template with the userform frmMain.
On this frmMain I have several buttons that creates and opens new documents
based on different templates.
When I have created a new document, filled it with the desired text and
saved it, I close it.
But when this document is closed, my frmMain is NOT visible. Only the
template containing my frmMain is showing, but the frmMain is not visible.
The reason is probably that I have the code frmMain.Hide in the code that
fills out my new document with text.
But this was neccesary, or else the frmMain was placed in front of my newly
created document.
I had to close the frmMain to get to my newly created document so I could
edit it some and then save/close it.
I don't want to close my frmMain until I'm all finished with all my new
documents.
The frmMain contains a lot of textboxes the the user fills out and all this
text goes into some bookmarks on the different documents.
So I have to have access to my frmMain after closing my newly created
documents.
I have figured out that VBA doesn't support the use of modal and modeless on
the forms.
Is there any other way to switch focus between documents/userforms??
Hope this makes any sense.
Gunnar