Form Macro Problem

T

Thejan Mendis

Hi,


I have created a form macro and it will automatically open. Because of that
I can not open a anther document or do any changer to a Opened document
until I close the macro form. Is there way to me access another word
document freely with out closing the form.

THEJAN
 
M

mksmith

May I suggest opening the form (i.e. your dialog box) in a modeless state?

But be careful when you handle and dispose of the form object and pointer.

Malc
www.dragondrop.com
 
M

Mark Tangard

Hi Thejan,

If by "freely" you mean manually (that is, by using the menus
yourself), you can do that (in Word 2000 and later) by making
the form "modeless"; change the line that launches the form,
which is probably like this:

MyUserFormName.Show

to:

MyUserFormName.Show vbModeless

Be aware that this brings on a pile of other considerations,
not the least of which is that the form loses some of its
"immediateness" -- that is, a normal ("modal") userform
has to be attended to before the user can do anything else.
And often that's what you need -- that is, the reason you
build a userform rather than a protected form is to require
the user to do something (fill blanks, checkboxes, etc.).
And there's no way to change a userform from modeless to
modal in the middle of execution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top