"Document not saved" state - what are possible (vba code) causes ?

See other post in this (excel-programming-vba-macros) to sit: 1417603-microsoft-excel-document-not-save-able-after-code-successfully-run-in-beforesave-event.html#post5907607 - ( sorry site not letting post links yet (not even to itself )

Summary - Results from code in a BeforeSave event. Solution - avoid such code - see indicated post.


{ Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 32-bit }

If your code Closes a Window which is not active, and said code is run from an ActiveX control on a sheet, then the state/error occurs.

E.g.

Please Login or Register  to view this content.

would run okay on its own, or from a form control . It does runs okay from ActiveX button; but subsequently you can't save.

So not running from an ActiveX control or having code:

Please Login or Register  to view this content.

would be okay.


{ Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 32-bit }