hidden rows keep unhiding themselves!

Hi,

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

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

thanks to anyone who helps

Mark

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" wrote:

>
> Hi,
>
> I have a spreadsheet tracking some Customer job costs. When the job is
> complete I hide the row. Problem is I use autofilter a lot which
> promptly unhides them!
>
> Is there any way of stopping this? If not can I mark the rows to be
> hidden with say a h in a column and then use a command button to kick
> off some vb code which goes through the spreadsheet rehiding the rows?
> What would the vb code be?
>
> thanks to anyone who helps
>
> Mark
>
>
> --
> Markathepub
> ------------------------------------------------------------------------
> Markathepub's Profile: http://www.excelforum.com/member.php...fo&userid=3532
> View this thread: http://www.excelforum.com/showthread...hreadid=488828
>
>

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