ExcelBanter - runtime error '1004' object '

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - runtime error '1004' object '_Global' failed (https://www.excelbanter.com/excel-programming/336200-runtime-error-1004-object-_global-failed.html)

Jim in Spokane[_2_]

runtime error '1004' object '_Global' failed

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

All times are GMT +1. The time now is 05:45 PM.