Excel Script Magic

[gbaughma]

I've got an excel document, that I need to do a little "magic" on.

It's simple, really... a column with names, then columns with things to be "checked".

i.e.

Last Name First Name Customer?
-------------------------------------------
Smith John X

Now, I know there's a way to do something like a Worksheet_SelectionChange event perhaps, so that all someone has to do is CLICK on the cell with the "X" to either place or remove the X. Just click the cell, and the "X" appears, or disappears if it is already there.....

Part 2...

When I print this, I need to *ONLY* print the rows that have an "X" in those cells.

Would I do this by looping through the rows, and setting the print area to include those rows?

Any help would be GREATLY appreciated. I don't want to do it with actual ActiveX checkboxes, because there will end up being several hundred, and I don't want it to be that slow loading...



Just my 2¢
-There once was a man from Peru
Who wanted to write a Haiku
but...

--Greg

http://parallel.tzo.com

 

[PHV]

To print only the rows you want you may consider an AutoFilter on the customer? column.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886