Allow only Hyperlinks
 

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

Allow only Hyperlinks
 

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.

--
Regards,
Tom Ogilvy


"Libby" wrote in message
...
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