How do I stop the Hyperlink activating in many cells?

Not for one cell, but for many at the same time?

Regards

Marcus

Hi Marcus,
See my reply to anonymous Ian.

You have a choice in Excel 2002 and up of stopping all
hyperlinks from being created under AutoComplete
or letting them get created. Not only would that not
be selective for some cells it would apply to all of Excel (I think).

You can use a macro to remove those hyperlinks, either at
once or just after one gets created.. So your restrictions
as to which one would have to be in the macro.
-
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

"Marcus" wrote in message ...
Not for one cell, but for many at the same time?

Regards

Marcus