Only print the filled cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hamidam - 05 Aug 2006 20:06 GMT

Hi, I am doing an ordering excel "tool" :) , where its possible to orde
among tousands of products.

I would like to as the user chooses to print the orderinglist, only th
filled cells should be printed, and not 100 pages, understand? :cool:

The orders are daily and the user threats like about 20 companys at th
same time, so if C2 (C1 = "Company 1") is filled and D5 (D1="Company 2
then i would like the produkts on A2 and A5 with those companys printe
automatically...

I understand you can use autofilter, but then the (dumb) :eek: use
would have to do it every time, print , and change all of them back t
normal again...

Thanks / Jennife

Reply to this Message

Dave Peterson - 05 Aug 2006 21:26 GMT

Maybe you could record a macro that:
uses autofilter to hide the rows you don't want printed
prints the worksheet
unhides the rows

You could record a macro when you do it once, then drop a button from the Forms
toolbar onto that sheet. And assign your macro to that button.

> Hi, I am doing an ordering excel "tool" :) , where its possible to order
> among tousands of products.
[quoted text clipped - 18 lines]
> Hamidam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37138
> View this thread: http://www.excelforum.com/showthread.php?threadid=568671

Signature

Dave Peterson

Reply to this Message

Hamidam - 05 Aug 2006 22:02 GMT

I always wondered what a macro is and now i know! :)

But unfortanly, crap windows (microsoft) doesn't allow more than on
active window, so if I push the print button i can't stop the macr
unless i press cancel or print... so the options for the printe
disappears... but if I don't find any other way your's is useful ..
thanks alot / Jennife

Reply to this Message

Hamidam - 06 Aug 2006 19:12 GMT

you wrote "then drop a button from the Form
toolbar onto that sheet. And assign your macro to that button.

drop a button from the Forms toolbar onto that sheet?

I have only succeded into dropping a button among the other icons (i.
bold, zoom and those icons, when I choose adjust(? don't have th
english version) after rightklicking on for example bold, chooses th
option at the bottom of that list (adjust?) )

and not onto the sheet... and I guess that if the files is run on som
other computer that button won't be there right

Thanks / Jennife

Edit... ok... now i get it... haha... always to late! thanks Dave

Reply to this Message

Dave Peterson - 06 Aug 2006 19:28 GMT

Show the Forms toolbar
(View|toolbars|check Form)

click on the button icon and draw a button on the worksheet itself--not in the
toolbar area.

I like to freeze windows so that row 1 is always visible and put the buttons in
that area.

> you wrote "then drop a button from the Forms
> toolbar onto that sheet. And assign your macro to that button."
[quoted text clipped - 18 lines]
> Hamidam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37138
> View this thread: http://www.excelforum.com/showthread.php?threadid=568671

Signature

Dave Peterson

Reply to this Message