Set a column to not print

[Jenni]

I have a worksheet that will be used for scheduling our
workforce. It lists employees with their wages, and then
shaows an average wage for each job once the workforce
has been scheduled. The problem is the person who will be
doing the scheduling loves to print things an lay them on
his desk, for everyone to see. We can't have everyone
seeing everyone elses wage data, so I would like to set
it up so that when he prints, the wage data will either
be blank or show number signs or something. I know he
could hide the columns, but that's a bit advanced for
him. Is there another way?

 

[Don Guillett]

Why not just hide the columns for him in a macro

columns(3).hidden=true 'hide columns
yourrange.printout
unhide colums

 

[Peo Sjoblom]

You could have a before print macro that hides a particular column, prints
the sheet
and unhide the column. Of course a macro can be disable when you open the
workbook.
That way he just click the print icon with everything setup to hide this
particular column/row just
when he prints?

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)