Prev: Warning when in another cell after entering a formula.
Next: Help with conditional formatting...
From: eddie57 on 20 Mar 2010 18:59

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
From: Dennis Tucker on 21 Mar 2010 12:21
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" <eddie57.5eb33e8(a)officefrustration.com> wrote in message
news:eddie57.5eb33e8(a)officefrustration.com...
>
> 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

From: Don Guillett on 21 Mar 2010 13:59
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
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"eddie57" <eddie57.5eb33e8(a)officefrustration.com> wrote in message
news:eddie57.5eb33e8(a)officefrustration.com...
>
> 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

From: eddie57 on 21 Mar 2010 16:40

'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
> dguillett(a)gmail.com
> "eddie57" eddie57.5eb33e8(a)officefrustration.com wrote in message
> news:eddie57.5eb33e8(a)officefrustration.com...-
>
> 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
From: Don Guillett on 21 Mar 2010 18:21
It is a MACRO.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"eddie57" <eddie57.5ec4d26(a)officefrustration.com> wrote in message
news:eddie57.5ec4d26(a)officefrustration.com...
>
> '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
>> dguillett(a)gmail.com
>> "eddie57" eddie57.5eb33e8(a)officefrustration.com wrote in message
>> news:eddie57.5eb33e8(a)officefrustration.com...-
>>
>> 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

 |  Next  |  Last
Pages: 1 2
Prev: Warning when in another cell after entering a formula.
Next: Help with conditional formatting...