I'm a novice when it comes to macros I'm afraid. I have a spreadsheet that lists work for several members of my team. When it's completed I don't want to delete it, so have a macro to hide all rows where "Y" is entered into the completed column. So far, highlighting all rows and unhiding has been fine as we have had a very small amount of work, but as time goes on and there's more and more it would be much easier to have another button with a 'show all rows' macro assigned to it. Can anyone help me out here?

Thanks very much.