Re: UserForms - Templates and Documents
- From: "Charles Kenyon" <msnewsgroup@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 14:10:07 -0500
I was thinking that the Title could hold the some characters, even if
possibly not enough.
Word New User FAQ & Web Directory: http://addbalance.com/word
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"David Sisson" <dsisson@xxxxxxxxxxx> wrote in message
>> If the doc file is zipped and emailed to another user, the userform and
>> the line of code that shows the form is stripped
> Worked as designed.
>> Without forcing several hundred users to install add-ins or global
>> templates, is there a way to add the userform to the resulting doc file?
> Save the dot file as a doc file and distribute. I would password
> protect your code. But as Charles already stated, your end users will
> probably have macro security issues.
>> problem. The MsgBox function only allows 1024 characters in the prompt
>> string, and about 1200 are needed.
> The title property also has a 1024 limit, plus it gets trunicated after
> 76 characters.
> Create a userform with a label. Make the label as big as you need to
> hold your text.
> Another option would be to build a Windows help file and link it to the