Activating hyperlinks in Excel Spreadsheet

Clarifications

With the required cell selected, this will make the cell into a link:

Code:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"http://www.hyperlink.com", TextToDisplay:="www.hyperlink.com"

Do it manually by striking F2 and then striking enter. Afterwards, the hyperlink would/should become active.

Though you have many to activate, i would get started now. You could use
Re: Activating hyperlinks in Excel:
When focus is on a cell with a hyperlink, press the applications key (to the
left of the right hand Control key) or Shift + F10 to get a context menu. Near
the bottom of the menu is "Open hyperlink" which will do the job.

I have several spreadsheets, not with as many hyperlinks as yours, and I don't have to do what you do to get them to work. Is there a setting that's been changed?

EMD

I know you must have solved the problem by now, but for anyone else who stumbles across the post. I've just had to create 600 hyperlinks to automatically dial some telephone numbers using a SIP (VOIP) phone. The numbers were listed in column A, I wanted to create hyperlinks in a diferent column and used the following formula =HYPERLINK("SIP:"&A2) where SIP: is the command to activate the SIP phone and A2 was the cel lcontaining the telephone number. I then copied the formula down the spreadsheet. Or to cut a long explanation short insert a new column and use the command =HYPERLINK(A2) and copy the formula.

Just go into your spreadsheet, select the column containing the hyperlinks and type Ctrl + F to open Find and replace. Then "find" www or something else that's in every cell and "replace" it with the same thing. You'll make excel think you have just typed in every one of the cells and will activate your hyperlinks (provided you have the 'replace as you type' option checked in your auto-correct options.)