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
it not to print the shading? Thanks in advance
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dennis Tucker
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
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
D
Don Guillett
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
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
E
eddie57
'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.
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
D
Don Guillett
It is a MACRO.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
--
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.
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.
E
eddie57
Is there a way to copy and paste that macro formula to create tha
macro?
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.
D
Don Guillett
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)
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.
G
Gord Dibben
Woiuldn't it be easier to just print in Draft Quality?
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.