If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Shade a Cell
How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance.
|
#2
|
|||
|
|||
Shade a Cell
A fairly simple way to do this is;
1. When you are ready to print(but do not print), save your document as a ..CSV file. This save all the data without any formatting. 2. Close all files in excel. 3. Open the .CSV file you just created with Excel, setup your printing preferences and print. Dennis "eddie57" wrote in message ... How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance. -- eddie57 |
#3
|
|||
|
|||
Shade a Cell
Sub printcleansheet()'change printPREVIEW to printOUT
ActiveSheet.Copy Befo=Sheets(1) With ActiveSheet ..UsedRange.Value = .UsedRange.Value ..UsedRange.Interior.ColorIndex = xlNone ..PrintPreview Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "eddie57" wrote in message ... How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance. -- eddie57 |
#4
|
|||
|
|||
Quote:
Not sure what your reply meant, but I guess it's some formula. I am not that diverse in excel so I am sure what I need to do. Thanks. |
#6
|
|||
|
|||
Is there a way to copy and paste that macro formula to create that macro?
Quote:
|
#7
|
|||
|
|||
Shade a Cell
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "eddie57" wrote in message ... Is there a way to copy and paste that macro formula to create that macro? 'Don Guillett[_2_ Wrote: ;3680975']Sub printcleansheet()'change printPREVIEW to printOUT ActiveSheet.Copy Befo=Sheets(1) With ActiveSheet ..UsedRange.Value = .UsedRange.Value ..UsedRange.Interior.ColorIndex = xlNone ..PrintPreview Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "eddie57" wrote in message ...- How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance. -- eddie57 - -- eddie57 |
#8
|
|||
|
|||
Shade a Cell
Woiuldn't it be easier to just print in Draft Quality?
Gord Dibben MS Excel MVP On Sun, 21 Mar 2010 09:21:16 -0700, "Dennis Tucker" wrote: A fairly simple way to do this is; 1. When you are ready to print(but do not print), save your document as a .CSV file. This save all the data without any formatting. 2. Close all files in excel. 3. Open the .CSV file you just created with Excel, setup your printing preferences and print. Dennis "eddie57" wrote in message ... How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance. -- eddie57 |
Thread Tools | |
Display Modes | |
|
|