|
|
|
date: Wed, 15 Mar 2006 17:58:02 +0530,
group: microsoft.public.word.vba.customization
back
Re: Format hyperlink as in vba
If I understand you, you're wanting the text inserted into the letter, but
for it nor to be formatted with the hyperlink style and not to be an active
hyperlink - nothing happens if you click on it.
if so, then the problem is that when you are inserting the text, probably
because of your AutoFormat settings in Word, it is automatically becoming a
hyperlink.
The simplest way to approach this is to check the Range of your inserted
text, and see if the Hyperlinks.Count property is greater than zero. If it
is, an hyperlink has been made. You can Delete the Hyperlink object, which
will leave the plain text there. You can then format that as you wish
--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
"nm_mcc" wrote in message
news:nm_mcc.24ppf1@NoSpamPleaze.com...
>
> I am inserting a hyperlink into a letterheads that is based on text in a
> user form. We are trying to format it to Arial 7 and 50%grey but it is
> taking on the Hyperlink style format of TNR 12. The area it sits in has
> a relevant bookmark range and the area is formatted as we want but the
> link still changes as it goes into the letter. A similar function is
> used for the email address at a bookmark which works fine. Any
> suggestions would be appreciated. Thanks in advance
>
>
> --
> nm_mcc
> Posted from - http://www.officehelp.in
>
date: Wed, 15 Mar 2006 13:12:51 -0000
author: Jonathan West
Re: Format hyperlink as in vba
Thanks for your prompt reply
Unfortunetely the link needs to be active but formatted as Arial 7 50%
grey.
Somehow the email link works fine
Jonathan West Wrote:
> If I understand you, you're wanting the text inserted into the letter,
> but
> for it nor to be formatted with the hyperlink style and not to be an
> active
> hyperlink - nothing happens if you click on it.
>
> if so, then the problem is that when you are inserting the text,
> probably
> because of your AutoFormat settings in Word, it is automatically
> becoming a
> hyperlink.
>
> The simplest way to approach this is to check the Range of your
> inserted
> text, and see if the Hyperlinks.Count property is greater than zero. If
> it
> is, an hyperlink has been made. You can Delete the Hyperlink object,
> which
> will leave the plain text there. You can then format that as you wish
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
> Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
>
> "nm_mcc" wrote in message
> news:nm_mcc.24ppf1@NoSpamPleaze.com...
> >
> > I am inserting a hyperlink into a letterheads that is based on text
> in a
> > user form. We are trying to format it to Arial 7 and 50%grey but it
> is
> > taking on the Hyperlink style format of TNR 12. The area it sits in
> has
> > a relevant bookmark range and the area is formatted as we want but
> the
> > link still changes as it goes into the letter. A similar function is
> > used for the email address at a bookmark which works fine. Any
> > suggestions would be appreciated. Thanks in advance
> >
> >
> > --
> > nm_mcc
> > Posted from - http://www.officehelp.in
> >
--
nm_mcc
Posted from - http://www.officehelp.in
date: Wed, 15 Mar 2006 19:46:44 +0530
author: nm_mcc
Re: Format hyperlink as in vba
Hyperlink is just a character style, same as any other. You can format it
however you like through the Styles pane. You might want to reformat
FollowedHyperlink also.
"nm_mcc" wrote in message
news:nm_mcc.24puqa@NoSpamPleaze.com...
>
> Thanks for your prompt reply
>
> Unfortunetely the link needs to be active but formatted as Arial 7 50%
> grey.
> Somehow the email link works fine
>
> Jonathan West Wrote:
>> If I understand you, you're wanting the text inserted into the letter,
>> but
>> for it nor to be formatted with the hyperlink style and not to be an
>> active
>> hyperlink - nothing happens if you click on it.
>>
>> if so, then the problem is that when you are inserting the text,
>> probably
>> because of your AutoFormat settings in Word, it is automatically
>> becoming a
>> hyperlink.
>>
>> The simplest way to approach this is to check the Range of your
>> inserted
>> text, and see if the Hyperlinks.Count property is greater than zero. If
>> it
>> is, an hyperlink has been made. You can Delete the Hyperlink object,
>> which
>> will leave the plain text there. You can then format that as you wish
>>
>>
>> --
>> Regards
>> Jonathan West - Word MVP
>> www.intelligentdocuments.co.uk
>> Please reply to the newsgroup
>> Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
>>
>> "nm_mcc" wrote in message
>> news:nm_mcc.24ppf1@NoSpamPleaze.com...
>> >
>> > I am inserting a hyperlink into a letterheads that is based on text
>> in a
>> > user form. We are trying to format it to Arial 7 and 50%grey but it
>> is
>> > taking on the Hyperlink style format of TNR 12. The area it sits in
>> has
>> > a relevant bookmark range and the area is formatted as we want but
>> the
>> > link still changes as it goes into the letter. A similar function is
>> > used for the email address at a bookmark which works fine. Any
>> > suggestions would be appreciated. Thanks in advance
>> >
>> >
>> > --
>> > nm_mcc
>> > Posted from - http://www.officehelp.in
>> >
>
>
> --
> nm_mcc
> Posted from - http://www.officehelp.in
>
date: Thu, 16 Mar 2006 18:17:22 +1100
author: Jezebel
|
|
