Excel asking users for VBAProject Password

[bdbBear]

I have an .xls file (winXP, XL03) that has the code password protected using the VBAProject password.

Some of the users get asked for the password even though they are not going into the IDE. Sometimes it pops up after they have closed out the file.

Anyone have any idea about this?

Thanks.

 

[rmikesmith]

See this thread: thread707-1168986
(and the linked thread it contains)

Regards,
Mike

 

[bdbBear]

Thanks.

Though I don't have any add-ins.

I am querying data from a second .xls file using ADODB. Could that be a cause?

    Dim cn As ADODB.Connection
    Set cn = New ADODB.Connection
    
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset

    With cn
        .Provider = "Microsoft.Jet.OLEDB.4.0"
        .Properties("Extended Properties").Value = "Excel 8.0"
        .Open namePath & nameFile
    End With

    rs.Open q, cn, adOpenStatic
    
    ' ... code for using data in recordset rs goes here.

    rs.Close
    Set rs = Nothing
    
    cn.Close
    Set cn = Nothing

 

[rmikesmith]

Using ADO is not the cause. As I mentioned in the other thread, there are apparently cases that cannot be attributed to Google Toolbar and are without resolution. I was hopeful that wasn't the case for you, given that it was occurring for some of your users but not others.

I don't have any other bright ideas at this time


Regards,
Mike

 

[bdbBear]

thanks!