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?
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
>
>.
>
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