Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Image on heder at VBA
to text i use :
Worksheets("Example").PageSetup.LeftHeader = "&B&12My left header" visalization: _______________________________________________ My left Header _______________________________________________ i would like to add an image at the begining of the left header new visalization: _______________________________________________ (||) My left Header _______________________________________________ legend : (||) - image jp -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Image on heder at VBA
Hi bilro,
You can do this with Excel 2002 or newer: With Sheet1.PageSetup .LeftHeaderPicture.Filename="c:\myimage.jpg" .LeftHeader="&G Howdy folks" End With The &G tells Excel where to put the image. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] bilro wrote: to text i use : Worksheets("Example").PageSetup.LeftHeader = "&B&12My left header" visalization: _______________________________________________ My left Header _______________________________________________ i would like to add an image at the begining of the left header new visalization: _______________________________________________ (||) My left Header _______________________________________________ legend : (||) - image jpg --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Image on heder at VBA
is it possible to do:
dim i as Image With Sheet1.PageSetup ..LeftHeaderPicture=i ..LeftHeader="&G Howdy folks" End With or somethig for the style??? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
image url | Excel Worksheet Functions | |||
Automatically adding image extension ".jpg" to end of image name | Excel Discussion (Misc queries) | |||
Image | Excel Worksheet Functions | |||
Transfering one image to another image | Excel Discussion (Misc queries) | |||
Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions |