Running VBA find method on a workbook with a signature

[crewaustin66]

I have a workbook with macros. The workbook has a signature on it that locks it down from being editable. That's fine. The problem is that most of my macros works fine except for the ones that do a range().Find and I don't know why that fails. Has anyone seen this and gotten around it before?

Example code:

Function IsGLSUSheet(sheet As Object) As Boolean    ' 2034 5/20/14 -car- Added function to determine if a sheet looks like a GLSU sheet.
    Dim bk As Range
    Dim bs As Range
    On Error Resume Next
    
    Set bk = sheet.Range("A:A").Find("BKPF")
    Set bs = sheet.Range("A:A").Find("BSEG")
    If bk Is Nothing Or bs Is Nothing Then
        IsGLSUSheet = False
    Else
        IsGLSUSheet = True
    End If
End Function

When the document is not signed, this works fine. When it is signed, the .Find methods always return "nothing".

Thanks,
Crew

 

[Fluff]

The fact that it's digitally signed should make no difference.
if you remove this line

On Error Resume Next

what happens?
Also how are you calling the function?