View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel.links
David McRitchie
 
Posts: n/a
Default How to keep cell font setting after inserting hyperlink

Hi Ed,
Thanks for the corrections, didn't realize you HAD to select a fontsize
under modify as opposed to letting it default. While fontsize is changed
immediately it appears that color is applied only to the selection range
or actually that everything in the selection range would be changed to
hyperlink style, whether it's a hyperlink or not.

Need a little work on understanding SCOPE of style changes and can't narrow
anything down in Google about style in Excel.

Besides "hyperlink" style there is also "followed hyperlink" style and that
seems to kick in once the hyperlink is selected during normal usage
of a hyperlink (it has it's own fontsize)..

Good grief, look at all of the newsgroups selected, any mistake in one
is made to 3 newsgroups.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ed Ferrero" wrote in message ...
Use the Format - Style menu.

This opens a dialog box. If you have added hyperlinks to the worksheet, you
should see two styles added to the drop-down; Hyperlink and Followed
Hyperlink.

Select each of these in turn and click Modify - set the fornt size to what
you require, then click ok.

Ed Ferrero
http://www.edferrero.com


"come_mon_come_mon!" wrote in message
ups.com...

David McRitchie ??:

Style, Hyperlink from your menu, uncheck fontsize


Can't find out your suggested menu option. I don't know whether you are
talking about Format-Cell Format option or Tools-Options tabs (I
guess not so). Anyway, no option found in my menu has your suggested
function.

:(

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm