Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jason
 
Posts: n/a
Default Not printing a single cell's value.

I may be asking this question in the wrong forum, but the "printing group"
does not seem very active

Is it possible to have a cell's value shown on the screen but when the page
is printed the cell would appear blank. It is a value that users of the sheet
need to see but not those who would just be viewing it on paper. Thank you Jay
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

You can run a macro to hide the cell's contents, print
out the sheet, then unhide the cell's contents.

Something like:

Sub test()
'Change A1 to correct cell
Application.ScreenUpdating = False
With ActiveSheet
.[A1].NumberFormat = ";;;"
.PrintOut
.[A1].NumberFormat = "General"
End With
Application.ScreenUpdating = True
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----
I may be asking this question in the wrong forum, but

the "printing group"
does not seem very active

Is it possible to have a cell's value shown on the

screen but when the page
is printed the cell would appear blank. It is a value

that users of the sheet
need to see but not those who would just be viewing it

on paper. Thank you Jay
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
printing not within the cells Help me Print Excel Discussion (Misc queries) 0 March 4th 05 04:45 PM
Pasting single cells from Word to multiple cells in Excel ASBiss Excel Worksheet Functions 1 February 15th 05 11:47 AM
exporting single cells to Word Anja B Excel Discussion (Misc queries) 3 February 2nd 05 08:47 PM
Formatting cells for printing Steve S Excel Discussion (Misc queries) 1 January 19th 05 12:49 AM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"