ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sheet Background does not print (https://www.excelbanter.com/excel-worksheet-functions/151767-sheet-background-does-not-print.html)

Corey

Sheet Background does not print
 
I have set a sheet background.
Yet when i print the sheet i get NO background

How do i fix this ?

Corey....



NickHK

Sheet Background does not print
 
Whilst the help is not clear, especially suggesting using a watermark:
Worksheets(1).SetBackgroundPicture "c:\graphics\watermark.gif"

this behaviour is by design.
Maybe your print driver supports inserting a back ground picture ?

NickHK

"Corey" wrote in message
...
I have set a sheet background.
Yet when i print the sheet i get NO background

How do i fix this ?

Corey....





Gord Dibben

Sheet Background does not print
 
If you are setting the background through FormatSheetBackground it will not
print.

Just for viewing only.

To print a background or watermark see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0005.html


Gord Dibben MS Excel MVP

On Thu, 26 Jul 2007 13:33:49 +1000, "Corey" wrote:

I have set a sheet background.
Yet when i print the sheet i get NO background

How do i fix this ?

Corey....



Corey

Sheet Background does not print
 
Thanks guys.

In the ideal world of MSOffice, i suppose ALL features would be available to ALL Office applications
at ALL times.


Corey....


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
If you are setting the background through FormatSheetBackground it will not
print.

Just for viewing only.

To print a background or watermark see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0005.html


Gord Dibben MS Excel MVP

On Thu, 26 Jul 2007 13:33:49 +1000, "Corey" wrote:

I have set a sheet background.
Yet when i print the sheet i get NO background

How do i fix this ?

Corey....





All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com