I am using Office 365 and my file is saved to OneDrive. During general activity on the sheets everything is fine and AutoSave works ok.
But sometimes, eg when I update from an Access database and a macro can be running for longer that the AutoSave takes to kick in, the yellow message bar with an 'Unable to save' message comes up and then asks you to Save As. The file can't be saved with it's original name, presumably because the lock file is there, so I have to manually save as a temp file name and then back to its original name... a lot of faff!
Is there a way to detect when the yellow message bar pops up in VBA? I can then run a script to do the saving programatically.
Best regards
Paul Ked