Fair enough ... but you could just type rows.hidden=false in the Immediate window.

Or click on the intersection of the row and column headers to select all and choose Format | Hide & Unhide | Unhide rows

Seems a macro is a bit of overkill and then you'd have to remove the module if there was no other need for macros in order to save the file (given the profile is 2007).

But, whatever, I won't lose sleep if it does the job.