I have tried the follow. I started using a button with an Action that ran a macro with the following Code.
'get the text object and update the display text
Set targetOBJ = Activedocument.GetSheetObject("TX01")
Set tProp = targetOBJ.GetProperties
tprop.Layout.Text.v = "Loading ...."
'get the desired chart and restore it from minimized
Set targetCH = Activedocument.GetSheetObject("CH04")
'revert the text object back to a blank value
tprop.Layout.Text.v = ""
I have simply put a text object(TX01) on the screen, and when the button is pressed I would like the text box to be updated with 'Loading...' and then when the chart(CH04) is restored, I want the text of the text object to be blank.
It seams that the Restore function on the Chart does not wait for the operation to complete before returning. Because 'Loading..' never seams to appear in the text object. Is their a way to make the Restore method wait for the operation to finish before returning?