I have added a special formatting to a cell and also the value it
shows.
When I make this cell as a hyperlink to another sheet (Ctrl-K)
then Excel automatically changes the formatting of the cell
(It achanges the font size, added underline, and when one clicks the
hyperlink - the color also changes.)

I want the hyperlink *to change nothing in the formatting*
Is there a way to do that?


Thanks!


--
snoach
------------------------------------------------------------------------
snoach's Profile: http://www.excelforum.com/member.php...o&userid=23795
View this thread: http://www.excelforum.com/showthread...hreadid=374486

I found this in the Excel help with the following search criteria
"hyperlink format":

When you make changes to the Hyperlink and Followed Hyperlink styles,
your changes apply to all hyperlinks in the current workbook.

On the Format menu, click Style.
To change the appearance of hyperlinks before or after they have been
clicked to make a jump, click Hyperlink or Followed Hyperlink in the
Style name box.
Click Modify.
Select the options you want, and then click OK.
Clear the check boxes for any options you don't want.
Click Add, and then click Close.
Note The Hyperlink style appears in the Style name box only if you
have previously created a text hyperlink in the workbook. The Followed
Hyperlink style appears only if you have used a text hyperlink in the
workbook to jump to another file and then returned to the original
workbook.


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374486

You'll have to change the formatting for the styles Hyperlink and
Followed Hyperlink. Change the font color to Automatic for both, and
the underline to none.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374486