I have a spreadsheet that is used find out what items a client wants to order.
What I want is a column of check boxes, if a check box is unchecked, it's row is hidden in the print preview.
If the item is checked, then it's row shows up to print. I only want the unchecked rows to be hidden for the print though.
I need a macro that can do this, every time I try to modify and piece together commands to try and accomplish this there
is a fault with my coding.
Has anyone done this before?
Thanks