I have a code that did work but then stopped for some users and now, after some time, also for me most of the time. It does not work when automatically run when opening excel, but it does work when I run it myself. I receive error 1004. Macro is placed in ThisWorkbook module. Please help to find the reason for the issue.