Can you auto answer a dialog during a recorded macro?

[steviejay]

I have recorded some steps including cell merge and splitting. When the merge step is recorded, the dialog box to merge the hidden cell is answered in the macro, yet on running it would be better auto-answered in the affirmative.

I understand why it is requiring an answer by default but is there a way to override this default behaviour?

Calc 5.0.2.2. en-gb
Windows 10 Home x64
JRE 8u60 32-bit

[jadeye]

AFAIK: Recording a Macro

Limitations of the macro recorder
The following actions are not recorded:

• Opening of windows is not recorded.
• Actions carried out in another window than where the recorder was started are not recorded.
• Window switching is not recorded.
• Actions that are not related to the document contents are not recorded. For example, changes made in the Options dialog, macro organizer, customizing.
• Selections are recorded only if they are done by using the keyboard (cursor traveling), but not when the mouse is used.
  The macro recorder works only in Calc and Writer.