Hide row before printing
 

Sorry if this has been asked before. i didn't find what i was looking for
when searching this forum.

I would like to create a button to print a worksheet but hide a certain
column "D" only when printing. but not hide on the worksheet. for me i know i
can hide the column, print, then unhide but this is for someone with no excel
basics at all.

Many Thanks in Advance
Greg

Hide row before printing
 

Hi Greg

See the examples on this page
http://www.rondebruin.nl/print.htm#Hide

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg" wrote in message ...
Sorry if this has been asked before. i didn't find what i was looking for
when searching this forum.

I would like to create a button to print a worksheet but hide a certain
column "D" only when printing. but not hide on the worksheet. for me i know i
can hide the column, print, then unhide but this is for someone with no excel
basics at all.

Many Thanks in Advance
Greg

Hide row before printing
 

Thank You! That worked perfectly. I also tweaked some other printing function
by visiting your site.

Once again Thanks.
Greg

"Ron de Bruin" wrote:

Hi Greg

See the examples on this page
http://www.rondebruin.nl/print.htm#Hide

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg" wrote in message ...
Sorry if this has been asked before. i didn't find what i was looking for
when searching this forum.

I would like to create a button to print a worksheet but hide a certain
column "D" only when printing. but not hide on the worksheet. for me i know i
can hide the column, print, then unhide but this is for someone with no excel
basics at all.

Many Thanks in Advance
Greg
.

Hide row before printing
 

You are welcome

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg" wrote in message ...
Thank You! That worked perfectly. I also tweaked some other printing function
by visiting your site.

Once again Thanks.
Greg

"Ron de Bruin" wrote:

Hi Greg

See the examples on this page
http://www.rondebruin.nl/print.htm#Hide

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg" wrote in message ...
Sorry if this has been asked before. i didn't find what i was looking for
when searching this forum.

I would like to create a button to print a worksheet but hide a certain
column "D" only when printing. but not hide on the worksheet. for me i know i
can hide the column, print, then unhide but this is for someone with no excel
basics at all.

Many Thanks in Advance
Greg
.