| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight in Excel but do not print out
I want to highlight some cells to flag me to fill those in. Is there a way to
show the highlighted part on the screen but NOT when it is printed? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight in Excel but do not print out
Hi
file | page setup | Shhet tab - check the B&W box hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "texansgal" escreveu: I want to highlight some cells to flag me to fill those in. Is there a way to show the highlighted part on the screen but NOT when it is printed? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight in Excel but do not print out
I have to have other cells be in Color though.
"Marcelo" wrote: Hi file | page setup | Shhet tab - check the B&W box hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "texansgal" escreveu: I want to highlight some cells to flag me to fill those in. Is there a way to show the highlighted part on the screen but NOT when it is printed? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight in Excel but do not print out
so use a code to eliminate the highlight of these cells, print and highlight
again *********************************** Sub colored() Range("YOUR RANGE").Select Selection.Interior.ColorIndex = xlNone Range("A1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("YOUR RANGE").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Range("A1").Select End Sub ************************************************** ****** hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "texansgal" escreveu: I have to have other cells be in Color though. "Marcelo" wrote: Hi file | page setup | Shhet tab - check the B&W box hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "texansgal" escreveu: I want to highlight some cells to flag me to fill those in. Is there a way to show the highlighted part on the screen but NOT when it is printed? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How can I print on the front and back of a page in excel? | Excel Discussion (Misc queries) | |||
| How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002? | Charts and Charting in Excel | |||
| Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
| Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
Hybrid Mode
