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

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

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

'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 -



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.




--
eddie57

It is a MACRO.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"eddie57" wrote in message
...

'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 -



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.




--
eddie57

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

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

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