Prev: Using function IF in WORD 2003
Next: change font size of first character
From: donna on 27 May 2010 16:11
I have managed to create a word document and the user form behind it to ask
and populate questions.

What i am having trouble with is when i send the document to someone else
the userform does not appear for them to input the answers to the prompts.

Any ideas.
From: Fumei2 via OfficeKB.com on 27 May 2010 16:59
Version please.

Essentially, you need to have a procedure to Show the userform. If you want
it to Show on opening the document, you need to have that instruction in the
Document_Open event. This is in the ThisDocument code module.

Sub Document_Open()
Userform1.Show
End Sub

Now when the document is opened, the userform will display.

Caveat:

The userform MUST be in the document VBProject. If it is in a template then
it will NOT be in the document.

donna wrote:
>I have managed to create a word document and the user form behind it to ask
>and populate questions.
>
>What i am having trouble with is when i send the document to someone else
>the userform does not appear for them to input the answers to the prompts.
>
>Any ideas.

--
Gerry

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/201005/1

From: Doug Robbins - Word MVP on 27 May 2010 17:11
A macro needs to be run to show the user form. If the form is in a
template, the name of the macro would be AutoNew() so that when the user
created a file from the template by using File>New and then selected the
template, the macro would automatically run.

If what you are sending is actually a document that the you intent the user
to just open, the macro would be named AutoOpen(), BUT, there are a number
of issues. If the users Macro Security Level is set to High, the macro will
not run and the user will get no indication that it is being disabled. If
the level is set to the Medium Level (Disable macros with notification), the
user will be asked if they want to enable the macros in the document and the
macro will only run if they do enable them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"donna" <donna(a)discussions.microsoft.com> wrote in message
news:9B7D5C98-CE7C-48AB-A040-C1CD44A74BAD(a)microsoft.com...
> I have managed to create a word document and the user form behind it to
> ask
> and populate questions.
>
> What i am having trouble with is when i send the document to someone else
> the userform does not appear for them to input the answers to the prompts.
>
> Any ideas.

From: Graham Mayor on 27 May 2010 17:39
Undoubtedly you have saved the macros related to the user form in a template
that the remote user does not have access to. Move the macros and userform to
the document template and send the template. - see
http://www.gmayor.com/installing_macro.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



"donna" wrote:

> I have managed to create a word document and the user form behind it to ask
> and populate questions.
>
> What i am having trouble with is when i send the document to someone else
> the userform does not appear for them to input the answers to the prompts.
>
> Any ideas.
 | 
Pages: 1
Prev: Using function IF in WORD 2003
Next: change font size of first character