Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Image in Header
Hi
I am trying to insert an image into the header based on a variable in the same worksheet. I have a 'messy?' solution involving returning to a cell, a file name for an image. then using the following code, replace logo.jpg with the cell reference. Sub InsertPicture() With ActiveSheet.PageSetup.LeftHeaderPicture .Filename = "C:\Temp\logo.jpg" .Height = 100 .Width = 150 .Brightness = 0.36 .ColorType = msoPictureAutomatic .Contrast = 0.39 .CropBottom = 0 .CropLeft = 0 .CropRight = 0 .CropTop = 0 End With ' Enable the image to show up in the left header. ActiveSheet.PageSetup.LeftHeader = "&G" End Sub Is this a reasonable solution? What is the syntax? Any help is appreciated Graham |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Image in Header in front of data in cells | Excel Discussion (Misc queries) | |||
Header image blurry... | Excel Discussion (Misc queries) | |||
Variable IMAGE in document header | Excel Discussion (Misc queries) | |||
Image in a header | Excel Programming | |||
Image Variable | Excel Programming |