Hide - Unhide
 

Is there a way to "Lock" a row when you hide?
If I hide rows then use the auto filter for example to only show non blank
rows it Unhide everything and you cannot undo it, you manually have to hide
every row again.

Any suggestions?

Thanks,
Bob