You are correct! Say you click on a cell and type
http://www.cnn.com
and you want the link to be "clickable. BEFORE typing the hyperlink:

Tools Options Spelling AutoCorrect AutoFormat as you type and
check the Internet & Newwork paths checkbox.
--
Gary''s Student - gsnu200801


"Race Spanner" wrote:

I've noticed that in some excel files the hyperlink function is active, but
in other files it is not active. I haven't been able to figure out why some
files work and some don't. Is there some sort of worksheet protection
feature that allows some editing but does not allow hyperlinks?

Thanks