#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager
Here is yet another amazing thing that a worksheet user defined function (UDF) can do. It can add a picture file as a background to your worksheet.
Copy the following function procedure to a general module in your workbook.
Function AddBackground(fPath As String)
When this UDF is entered on the desired worksheet with a correct full path to the picture file to be shown, the background picture will appear. Note that gridlines cannot be turned off by using an UDF. So, if you want to, go the View on the ribbon and uncheck the Gridlines box.
I hope that you find this an useful and fun technique!