hidden rows keep unhiding themselves!

  • Thread starter Thread starter Markathepub
  • Start date Start date
M

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
 
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.
 
Back
Top