Special printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an area on a worksheet that I want to be invisible when viewed on the
screen. But, when I print the sheet, I want it visible on the paper only.
Is there a way I can do this?

thanks
 
Format the text as white, or hide the columns.
Record a macro that unhides the columns or formats the text back to a color,
then prints.
Assign the macro to a command button or toolbar button.
________________________

**** Hope it helps! ****

~Dreamboat
Finally! Excel VBA Certification
www.VBAExpress.com/training/
********************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell invisible when printed. 1
Disable Print Function 2
Userform to Select what worksheets to print 1
Excel VBA - Problem with Closing Print Preview 0
Print preview / full screen view problem 2
after print 2
print 2 sheets on one paper 5
Printing a long spreadsheet on 1 page only?? 2

Back
Top