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.
Sub test_Demo_Issue()
Dim oTempWindow As Excel.Window, oActvWindow As Excel.Window
Set oActvWindow = Application.ActiveWindow
Set oTempWindow = Application.ActiveWindow.NewWindow
oActvWindow.Activate
oTempWindow.Close
End Sub
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:
Sub test_Demo_Issue()
Dim oTempWindow As Excel.Window, oActvWindow As Excel.Window
Set oActvWindow = Application.ActiveWindow
Set oTempWindow = Application.ActiveWindow.NewWindow
oTempWindow.Close
oActvWindow.Activate
End Sub
would be okay.
{ Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 32-bit }
Bookmarks