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