Print certain cells

[daniels012]

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

 

[Tim]

Just go to File > Print Area > Set Print Area and
highlite the appropriate columns.

HTH
Tim

 

[Dave Peterson]

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.