Print certain cells  
Author Message
peppers





PostPosted: Wed Nov 17 08:24:05 CST 2004 Top

Excel Misc >> Print certain cells

We use a form for estimating jobs. It also has a lot of information for
our crews. Is there a way to print the form without any of the dollar
figures coming out.


Example: If we have
Product Amount Price
ItemABC 15 36.00

I would like it to only print Product and amount. I know when you have
a button or a forms control, you can have it print or not print. Is
there code I can write to have the form print in this special way?

Michael


--
daniels012
------------------------------------------------------------------------
daniels012's Profile: http://www.hide-link.com/ ;userid=8688
View this thread: http://www.hide-link.com/

Excel322  
 
 
Tim





PostPosted: Wed Nov 17 08:24:05 CST 2004 Top

Excel Misc >> Print certain cells Just go to File > Print Area > Set Print Area and
highlite the appropriate columns.

HTH
Tim

>-----Original Message-----
>
>We use a form for estimating jobs. It also has a lot of
information for
>our crews. Is there a way to print the form without any
of the dollar
>figures coming out.
>
>
>Example: If we have
>Product Amount Price
>ItemABC 15 36.00
>
>I would like it to only print Product and amount. I
know when you have
>a button or a forms control, you can have it print or
not print. Is
>there code I can write to have the form print in this
special way?
>
>Michael
>
>
>--
>daniels012
>---------------------------------------------------------
---------------
>daniels012's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=8688
>View this thread:
http://www.excelforum.com/showthread.php?threadid=314325
>
>.
>
 
 
Dave





PostPosted: Wed Nov 17 17:46:49 CST 2004 Top

Excel Misc >> Print certain cells You could hide that column, then print.

When you click on File|print, you'll see a "print what" in the bottom left
corner.

If you select the cells to print, you could just print that selection.

You could even record a macro when you did it once manually, then just run this
macro when you want to print later.




>
> We use a form for estimating jobs. It also has a lot of information for
> our crews. Is there a way to print the form without any of the dollar
> figures coming out.
>
> Example: If we have
> Product Amount Price
> ItemABC 15 36.00
>
> I would like it to only print Product and amount. I know when you have
> a button or a forms control, you can have it print or not print. Is
> there code I can write to have the form print in this special way?
>
> Michael
>
> --
> daniels012
> ------------------------------------------------------------------------
> daniels012's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8688
> View this thread: http://www.excelforum.com/showthread.php?threadid=314325

--

Dave Peterson