Adding Print only text to a worksheet

  • Thread starter Thread starter dcol
  • Start date Start date
D

dcol

I want to add text to certain rows of my worksheet which are visible only at
Print Preview/Print modes only.

I want these details to hide or preferablly to store in a seperate sheet
during edit to save screen space.

e.g : I want to display only the "Product part number" during edit. But to
included "indepth Product details" when I send it to Print/PrintPrview.

How to handle this?
 
you might want to use Workbook_BeforePrint in ThisWorkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
For Each cell In Selection
cell.Value = "indepth Product details: " & cell.Value
Next cell
End Sub
 
forgot to mention to select only those cells that have to be appended
with "indepth Product details"
 

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

Print worksheet 2 on back of worksheet 1, etc.... 1
Duplex Printing of Workbook with multiple worksheets 2
print/preview problem before saving an edited excel worksheet 1
problems printing entire worksheet 7
Print Area to include text box 10
Number of pages in worksheet doesn't match Print Preview pages 2
How do I get print preview to deslpay & print the color text. 4
printing partial worksheet 3

Back
Top