Firstly, my apologies for posting this question in a closed thread. I'm looking for a macro which will hide entire rows when "Completed" has been selected from a drop-down box. I'd also like to have a button which will toggle hidden rows. I know most of this can be achieved with filters, but I want something simpler (for users) and not so susceptible to change.
I got the macro which should work for me on this forum here
But I can't get this to work in Excel 2010. If I include the "(ByVal Target As Range)", Excel doesn't seem to recognise this as a macro.