View Single Post
  #9   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

Try this to see if it helps.

Go to the Format - Style menu. Click on the drop-down and enter 'MyLink' as
the style, this creates a new style. Uncheck everything except the Font box.
Click Modify and chane the Font settings to font size 10, bold, underlined,
color Green.

Now right-click a toolbar. Select Customize... from the context menu. Click
on the Format category. You should see the Style command in the right-hand
list. Click on the Style command and drag it to one of your toolbars.

Select a cell containing a hyperlink. You will see that the Style box that
you just dragged onto a toolbar shows the style is 'Hyperlink'. Change the
style to 'MyLink' using the toolbar drop-down.

Now the selected hyperlink is coloured green, all other hyperlinks still
have the 'Hyperlink' style and are not affected.

Note that if you edit the hyperlink it will revert to the 'Hyperlink' style.

Hope this helps with the scope.

Ed Ferrero
http://www.edferrero.com <-- its changed!


"come_mon_come_mon!" wrote
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.
<end quote