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


David McRitchie 寫道:

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" styleand 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.

---


I found another side effect of making the change. Originally, those
cells with hyperlinks inserted will have their font color changed from
default black to blue and text underlined. I don't need to place the
mouse pointer explicitly over the cell to check whether the cell has
hyperlink attached. After I made the change, all text appeared black,
regardless of whether the cells had hyperlinks assigned. That made me
confused because I need check each cell separately to see if hyperlink
was assigned.