Excell - Sorting

[blazblaz]

I have a sheet where using columns from A to M with some data.
I want to sort data based on column M descending, + column K descending from row 10-300. Column M have a values 1 or 0. After sorting from 300 rows only few will have value 1. I want to hide all rows which have value 0.
I want to do this in VB, so just clicking on some field to do automatically the above mentioned processing. Also after hiding rows with value 0 in column M, to set print area ready for printing.
The second function would be by clicking on another field programmed in VB to unhide all rows and to sort back the rows as original was.
Of course, I'd like to have protected sheet all the time i guess in VB it is possible to unprotect, sort, and protect
the sheet again.
Anyone VB programmer can help me?

 

[SkipVought]

blazblaz,

Turn on your macro recorder.

Go thru the process as stated above.

turn off the macro recorder.

Observe and clean up code.

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[blazblaz]

Can anybody explain me how can you record with macro to hide every rows from (1-64000) whatever has less then 1 for value in column M, after sorting? Also to set the page for printing to get printed the page with all rows and columns where the value in column M=1?

Thanks

 

[SkipVought]

Use AutoFilter.

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]