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