Module not loading on startup

[SystemHack]

I have created a module using Excel VBA with the following information

Function GetAddress(HyperlinkCell As Range)
GetAddress = Replace _
(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function

It works fine the first time. After closing the workbook and reloading it, the module no longer shows up on the Shift+F3 window under user defined, nor does the function =GetAddress work. I get a message stating that it is an invalid name.

On the VBA page, the module is still showing it simply no longer works. I am using Excel 2007.

Does anyone think they can help ?

[royUK]

What format of Excel have you saved as? It needs to be .xlsm - see

http://www.excel-it.com/Excel%202007/2007_Changes.htm.

Are you getting a Macro Security warning at the bottom left of the Ribbon, if so click Options & enable them.