OneDrive AutoSaves! Prompt user on opening every file to save a copy

[mib1019]

I use OneDrive for most of my files since I need access from to them from multiple computers. I have several files that I frequently opened just to change and save with new file name, keeping the original intact. If I forget to do this after a few edits, autosave kicks in and my original file is then changed.

I'd like Excel to prompt me on EVERY file opening, with a message box, asking me if I want to save a copy before making changes. If I say yes, obviously I want to prompt myself for a new file name and have it saved.

This macro should reside in Personal.xlsb. I'm having trouble getting it to work.

Surely, this has been brought up before, and a solution is out there, but I've not been able to find it.

Thanks

 

[ashakantasharma]

You can also disable auto-save option from Excel Settings.

 

[mib1019]

You can also disable auto-save option from Excel Settings.

Thanks for your reply.

Yes, I know I can disable Auto-Save. I don't really want to do that, since it's extremely helpful most of the time. It's a few files that I open, edit and want to save as new files.