creating hyperlinks to email
 

I have two simple workbooks open. One I have no problem in creating
hyperlinks to email - the other has the hyperlink function "greyed out" both
from the Insert tab as well trying to create from right click. (I don't know
if this is relevant but when I go file/properties/summary on the non
hyperlinked workbook, the summary details are also greyed out whereas on the
active hyperlinked workbook those details on the summary tab are active.)
I've searched everywhere as to why/how but no joy (this includes the website
exceltips)
--
phil b
australia