The easy answer is no.

Obviously if you close out the spreadsheet without saving it...it will
return your spreadsheet to the way it was last time you saved
it...which may or may not have been prior to the macro.

Sorry this isn't what you were looking for, but to my knowledge there
isn't a way to undo a macro.