Thread: Print Row
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
nman nman is offline
external usenet poster
 
Posts: 7
Default Print Row

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?


.



.