Colin

Macro......

Sub bkgrnd()
For Each Sheet In ActiveWorkbook.Sheets
Sheet.SetBackgroundPicture Filename:="E:\My Pictures\12345678.jpg"
Next
End Sub


Gord Dibben Excel MVP

On Fri, 20 May 2005 17:50:04 +0100, Colin Hayes
wrote:

HI all

I have a work book of 25 sheets. I want to apply the same background
image to all the sheets.

If I highlight all the tabs and use Format - Sheet - Background ,
Excel won't allow me to apply the background. Background is greyed out
in this circumstance.

Does this mean I have to go through the same process for each individual
sheet? This seems extremely long-winded. Or is there a way to apply the
same background to all the sheets all at one go?


Best Wishes


Drno