#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

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

ActiveSheet.SetBackgroundPicture Filename:=fPath

End Function

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!

Advertisements

4 thoughts on “#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

  1. Pingback: #Excel Super Links #101 – shared by David Hager | Excel For You

  2. Pingback: #Excel Super Links #104 – shared by David Hager | Excel For You

  3. Pingback: #Excel Super Links #105 – shared by David Hager | Excel For You

  4. Pingback: #Excel Super Links #107 – shared by David Hager | Excel For You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s