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

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