Autosaving file issue

Hi. I've created an excel file that I want to autosave every X number of minutes.

If the file is the only excel file open, it works fine. The issue I'm getting is if I'm working on different workbooks and the autosaving file is on in the background.

I tried putting all code inside the ThisWorkbook object, but then it alerts me the subfunction cannot be found.

Please Login or Register  to view this content.

Hello, I've managed to fix it. For anyone interested, I kept the code inside the Module1, and just used ThisWorkbook for the ranges.
The screen slightly flickers if you're on another excel file. Disabling screenupdating helps a little.

Please Login or Register  to view this content.