Thread: Print Row
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Print Row

As I stated in my initial response, you have to hide the row if you don't
want to print it. There is no other practical way.

--

Vasant

"nman" wrote in message
...
I need to attach the code (for each individual row) to
a "checkbox" so I can select the rows I don't want
printed. I do not want the row to disappear or "hide"
from the worksheet, just not print if the checkbox
contains a check.

-----Original Message-----
Try this
http://www.rondebruin.nl/print.htm#Hide



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message

...
New to this but I do understand your comments. Not

sure
what the code should be to not print a row (or range).

-----Original Message-----
You would have to write code to hide the row in order
for it not to be
printed. Also, how would you "reference" a row from a
checkbox? You would
probably need to use a linked cell to identify the row
that you want to
suppress.

--

Vasant


"nman" wrote in
message
...
I am searching for code that I can attach to a

checkbox
that will not allow a referenced row to be printed.
Any
advice?


.



.