Sub Main ForceUpdate End Sub sub ForceUpdate dim oCurrentController as variant: oCurrentController = ThisComponent.getCurrentController() dim oDoc as variant: oDoc=ThisComponent if not(oCurrentController.supportsService("com.sun.star.text.TextDocumentView")) then msgbox("Macro works only in text documents.") exit sub end if dim oModelTextDocument as variant: oModelTextDocument = oCurrentController.Model dim oEmbeddedObjects as variant: oEmbeddedObjects = oModelTextDocument.EmbeddedObjects dim nIndex as long dim nEndIndex as long: nEndIndex = oEmbeddedObjects.Count-1 dim oEmbeddedObject as variant: rem like green handle status dim oModel as variant: rem like edit status dim oXCOEO as variant: rem oExtendedControlOverEmbeddedObject for nIndex=0 to nEndIndex oEmbeddedObject = oEmbeddedObjects.getByIndex(nIndex) oModel = oEmbeddedObject.Model: rem might be empty; css.comp.math.FormulaDocument if Not(isEmpty(oModel)) then if oModel.supportsService("com.sun.star.formula.FormulaProperties") then rem It is a formula object. oXCOEO = oEmbeddedObject.ExtendedControlOverEmbeddedObject oXCOEO.update() end if end if next nIndex end sub