Ask Your Question

Can you auto answer a dialog during a recorded macro?

asked 2015-10-12 12:29:55 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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 en-gb Windows 10 Home x64 JRE 8u60 32-bit

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-11-12 09:34:03 +0100

jadeye gravatar image

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.
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-12 12:29:55 +0100

Seen: 65 times

Last updated: Oct 12 '15