Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work)

[o0omax]

No, I think I would need your full Excel project (and accompanying files) to troubleshoot this, not just some VBA code.
You need to find out what exactly causes the file to open and trigger the macro warning dialog. Anything goes for that matter, Autohotkey?

I replicated my files and attached them! But with this file, the problem does not appear!!! The only differences between those files are the complexity. The original Excel file i sadly cannot share has 30 worksheets and 5MB (like the PPT). Everythink else it the same. I dont use autohotkey.

I filmed it so you see where the security window appears. Here is the video (too big to attach it): https://drive.google.com/file/d/1HGV...ew?usp=sharing