On Fri, 2006-10-20 at 22:15 +1000, Terry wrote: > Guy Voets wrote: > > Hello > > > > In a Calc sheet, I have a column with mail addresses. Some are blue, > > underlined and with a grey background. When I click on one, I can send an > > e-mail. Others have the appearance of a normal entry and don't provide a > > link to my mail client. How can I 'activate' them to work as the blue > > ones? > > > > English OOo 2.0.4 on an iMac with OS X 10.3.9 > > > > Thanks > > -- > > Guy > There is a macro here which will do that: > > http://www.oooforum.org/forum/viewtopic.phtml?p=115605#115605
I usually have the opposite problem, I don't want to have live hyperlinks in my spreadsheets (contact spreadsheets with 10000 rows or more are already slow, and accidentally opening the mail client every so often doesn't help. I find that if you doubleclick to edit the grey one, it becomes a live hyperlink. doubleclick and add a space at the end of the email address. To get a live hyperlink to become dead, rightclick, or option/click and choose "Default". Wolf Halton Catwood Farms Anomaly Research
