Shade a Cell

  • Thread starter Thread starter eddie57
  • Start date Start date
E

eddie57

How can I shade a cell in Excel 2003 but when I print the document fo
it not to print the shading? Thanks in advance
 
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
 
Sub printcleansheet()'change printPREVIEW to printOUT
ActiveSheet.Copy Before:=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[_2_ said:
;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
(e-mail address removed)
"eddie57" (e-mail address removed) 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.
Click to expand...



Not sure what your reply meant, but I guess it's some formula. I am no
that diverse in excel so I am sure what I need to do. Thanks
 
It is a MACRO.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
eddie57 said:
'Don Guillett[_2_ said:
;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
(e-mail address removed)
"eddie57" (e-mail address removed) 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.
Click to expand...



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.
Click to expand...
 
Is there a way to copy and paste that macro formula to create tha
macro?


'Don Guillett[_2_ said:
;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
(e-mail address removed)
"eddie57" (e-mail address removed) 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.
Click to expand...
 
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
(e-mail address removed)
eddie57 said:
Is there a way to copy and paste that macro formula to create that
macro?


'Don Guillett[_2_ said:
;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
(e-mail address removed)
"eddie57" (e-mail address removed) 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.
Click to expand...
Click to expand...
 
Back
Top