When I open the Excel file via Excel my macro works fine.

When I open the file via Windows Explorer the macro errors with a
runtime error '1004' object '_Global' failed on the following line.

UserForm1.Label3 = Worksheets("tables").Range("name_select").Value

Any reason for this?

Thanks
Jim in Spokane