Just Autofilter on the name

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Sirvincent" wrote in message
...

Total Total Low Adjusted Final
Pt Test #1 Pt Test #2 Pt Test #3 Midterm Points Pt Test #4 Pt Final
Points grade points Average
Students #1 #2 #3 Test #4 #5 Test
Sam 5 88 10 73 176 176 73 103 14.71428571
Harry 0 95 5 88 188 188 88 100 14.28571429
Beth 4 100 8 65 177 177 65 112 16
Sally 10 70 5 42 127 127 42 85 12.14285714
0 0 0 0 0


I have a grade book and I wish to be able to blank out only indicated rows
thus allowing privacy to the students viewing the grades on screen.

I've attached my basic worksheet. As you can see I have frozen the
titles.
Now what I want to do is make everything beyond the first student
disappear
upon command and then reappear as needed.

Any ideas?