Excel - Hide Column/s or Change Font color Only for printing

[chris100]

Hi all,

Desperately need help on this....you'd think other people would have the same problem and it'd be easy to find, but all you get is hide and unhide column. This is too slow for me.

For an Invoicing system i need to hide prices that the salesman can look at on screen, but not be shown when printed. If hiding and unhiding columns or changing fonts whenever an order is made, i'm sure mistakes will happen.

So all i need is something that will hide or change the colour of certain cells or a column/s when the print button is clicked...simple.... ;¬)

Any help much appreciated.

please, please please and pretty please

[RagDyer]

Check out "Custom Views" in the Help files.

Sounds like that's just what you're looking for.

Each view can have it's own, separate print range. plus hide columns and
rows automatically as each view is invoked.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"chris100" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> Desperately need help on this....you'd think other people would have
> the same problem and it'd be easy to find, but all you get is hide and
> unhide column. This is too slow for me.
>
> For an Invoicing system i need to hide prices that the salesman can
> look at on screen, but not be shown when printed. If hiding and
> unhiding columns or changing fonts whenever an order is made, i'm sure
> mistakes will happen.
>
> So all i need is something that will hide or change the colour of
> certain cells or a column/s when the print button is
> clicked...simple.... ;¬)
>
> Any help much appreciated.
>
> please, please please and pretty please
>
>
> --
> chris100
> ------------------------------------------------------------------------
> chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
> View this thread: http://www.excelforum.com/showthread...hreadid=386633
>

[ScottO]

Assuming that your secret columns are F & G, you've already set up your
print area and other print settings, and that you want to unhide after
printing ...

Put a button on the sheet labelled "Print"
Assign the following macro to the button

Sub HideAndPrint()
Application.ScreenUpdating = False
Columns("F:G").Hidden = True
ActiveSheet.PrintOut Copies:=1
Columns("F:G").Hidden = False
Application.ScreenUpdating = True
End Sub

Click the print button to print.

Rgds,
ScottO

"chris100" <[email protected]> wrote in
message news:[email protected]...
|
| Hi all,
|
| Desperately need help on this....you'd think other people would have
| the same problem and it'd be easy to find, but all you get is hide and
| unhide column. This is too slow for me.
|
| For an Invoicing system i need to hide prices that the salesman can
| look at on screen, but not be shown when printed. If hiding and
| unhiding columns or changing fonts whenever an order is made, i'm sure
| mistakes will happen.
|
| So all i need is something that will hide or change the colour of
| certain cells or a column/s when the print button is
| clicked...simple.... ;¬)
|
| Any help much appreciated.
|
| please, please please and pretty please
|
|
| --
| chris100
| ------------------------------------------------------------------------
| chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
| View this thread: http://www.excelforum.com/showthread...hreadid=386633
|

[chris100]

Thanks for the help. I like ScottO's method a bit more. Just one question....considering that i'm not a programmer.

How do you adapt the script when the columns are not next to each other. e,g "B" and "D" without covering "C".

Thanks

[mangesh_yadav]

Separate them:

Columns("B").Hidden = True
Columns("D").Hidden = True


Mangesh

[chris100]

Thanks very much ScottO, Ragdyer and Mangesh.

The Macro works great - very handy for this type of thing.

Chris

[RagDyeR]

The one advantage "Custom Views" has over code,
For non-programmers like you and me ... revisions ... minor and/or major,
are more easily attainable.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"chris100" <[email protected]> wrote in
message news:[email protected]...

Thanks very much ScottO, Ragdyer and Mangesh.

The Macro works great - very handy for this type of thing.

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=386633