function error

[code_warrior]

I had a custom function that converts a hyperlink into a url from cell
to cell.

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function

It used to work just fine until today. I open excel get a macros error,
then the cells with the function now display a #NAME? AND #VALUE? ERROR.
What happened? The function form is just fine.

 

[Peo Sjoblom]

Where do you keep the function?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"code_warrior" <[email protected]>
wrote in message
news:[email protected]...

 

[code_warrior]

Its a custom function in a module in the VB editor

 

[Dave Peterson]

Did you enable macros when you opened the file?

I had a custom function that converts a hyperlink into a url from cell
to cell.

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function

It used to work just fine until today. I open excel get a macros error,
then the cells with the function now display a #NAME? AND #VALUE? ERROR.
What happened? The function form is just fine.

 

[code_warrior]

Yes, they ae set to high but it ave me an error saying it lost VD
Project. How could that happen?

 

[Dave Peterson]

I don't know. Maybe the workbook was corrupted somehow?

Can you restore from a backup?

 

[code_warrior]

No, Apparently macros had been disabled because the security level was
set to high was not digitally signed by a trusted cerificate. I guess I
can either lower the security level but the module is a VB module, why
wouldnt it be trusted?

 

[Dave Peterson]

Because anyone can give you a workbook with macros in it. And not everyone has
nice macros.

It's up to you to decide whom to trust.

But that doesn't explain how the project was lost????