Prev: Warning when in another cell after entering a formula.
Next: Help with conditional formatting...
From: eddie57 on 21 Mar 2010 22:16

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
> 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 -




--
eddie57
From: Don Guillett on 22 Mar 2010 09:14
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
dguillett(a)gmail.com
"eddie57" <eddie57.5eca188(a)officefrustration.com> wrote in message
news:eddie57.5eca188(a)officefrustration.com...
>
> 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
>> 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 -
>
>
>
>
> --
> eddie57

From: Gord Dibben on 22 Mar 2010 11:16
Woiuldn't it be easier to just print in Draft Quality?


Gord Dibben MS Excel MVP

On Sun, 21 Mar 2010 09:21:16 -0700, "Dennis Tucker" <dennis13030(a)cox.net>
wrote:

>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

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