Problem with Protected View from download

[mapline]

Hi

I have and excel file with vba code.

When sent to another person it correctly opens in protected view. When I click the "enable editing" it runs the code but comes up with an error when "ActiveWorkbook.Name" finds no workbook.

Restart the workbook and all is fine.

Any thoughts please?

 

[mapline]

Found the problem.
Previously on opening I had put ThisWorkbook.Name and no error.
Changed it to ActiveWorkbook.Name and error as workbook had not been made active.

Only showed up after download.