Allow only Hyperlinks

[Guest]

Hi

What I want is to set a range of cells to only allow a hyperlink to be
entered. I looked under Data Valiation but there is nothing listed. Is there
any way of rejecting the contents of a cell unless it's a Hyperlink?

Many thanks in advance
Libby

 

[Tom Ogilvy]

Possibly use the Change event to evaluate the entry.

http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events if your are not familiar.