You could copy it to the clipboard, or save it as a building block, or save it to Spike.

Another alternative is to create an undo record at the start of the macro so the user can simply undo if they weren't happy with the result of the macro. A good example of this can be seen in this thread https://www.msofficeforums.com/word-...-undo-all.html

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia