If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I stop the Hyperlink activating in many cells?
Not for one cell, but for many at the same time?
Regards Marcus |
#2
|
|||
|
|||
How do I stop the Hyperlink activating in many cells?
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 |
Thread Tools | |
Display Modes | |
|
|