function error

  • Thread starter Thread starter code_warrior
  • Start date Start date
C

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.
 
Did you enable macros when you opened the file?

code_warrior said:
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.
Click to expand...
 
Yes, they ae set to high but it ave me an error saying it lost VD
Project. How could that happen?
 
I don't know. Maybe the workbook was corrupted somehow?

Can you restore from a backup?
 
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?
 
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????
 
Back
Top