hidden rows keep unhiding themselves!

[Markathepub]

Hi,

I have a spreadsheet tracking some Customer job costs. When the job i
complete I hide the row. Problem is I use autofilter a lot whic
promptly unhides them!

Is there any way of stopping this? If not can I mark the rows to b
hidden with say a h in a column and then use a command button to kic
off some vb code which goes through the spreadsheet rehiding the rows
What would the vb code be?

thanks to anyone who helps

Mar

 

[Eddie O]

If you're actually doing this while at a pub, God bless you.
I'd suggest putting an "h" in a column as you mentioned, and then just
keeping the autofilter on to filter out that column (which will hide the
rows). When you want to filter additional criteria using the autofilter, you
can, and when you're done just keep your "h" filter on to hide those rows.

 

[Markathepub]

Actually that would do the trick Eddie, why didn't I think of that! Man
thank